Athena

Access configuration details to connect Soda to an Amazon Athena data source.

Connection configuration reference

Install the following package:

pip install soda-athena>4

Data source YAML

Create the config file:

soda data-source create -f ds_config.yml

The data source configuration YAML should look like the following:

ds_config.yml

type: athena
name: my_athena
connection:
  catalog: ${env.ATHENA_CATALOG}
  access_key_id: ${env.ATHENA_ACCESS_KEY_ID}
  secret_access_key: ${env.ATHENA_SECRET_ACCESS_KEY}
  staging_dir: ${env.ATHENA_STAGING_DIR} ## e.g., s3://my-company-athena-staging/query-results/
  region_name: ${env.ATHENA_REGION}
  work_group: ${env.ATHENA_WOKRGROUP}
#  role_arn: <my_role_arn>
#  profile_name: <my_aws_profile>
#  session_token: <my_session_token>

Connection test

Test the data source connection:

soda data-source test -ds ds_config.yml

---

You are not logged in to Soda and are viewing the default public documentation. Learn more about Documentation access & licensing.