Configuring your AWS Athena destination.
ACCOUNT_ID
, WORKGROUP
, BUCKET_NAME
and SCHEMA
with the your account information.
WORKGROUP
should be primary
unless otherwise specified during connection configuration.BUCKET
should refer to the bucket created in the previous step.SCHEMA
used below does not need to be created ahead of time. If it does not exist, it will be created automatically before transferring data.schema
should be the name of the folder in S3 under which the final data will be written.database
should be the name of the folder in S3 in which the Athena query results are written (i.e., the automatically generated athena_output/
data).transfer-service-policy
(this will be referenced in the next step), add a description, and click Create policy.transfer-role
, and click Create role.transfer-service
, click Next. Under Select AWS access type, select the Access key - Programatic access option. Click Next: Permissions.