Athena setup

Overview of dbt-athena-community

• Maintained by: Community
• Authors: Community
• GitHub repo: dbt-athena/dbt-athena
• PyPI package: dbt-athena-community
• Slack channel: #db-athena
• Supported dbt Core version: v1.3.0 and newer
• dbt Cloud support: Not Supported
• Minimum data platform version: engine version 2 and 3

Installing dbt-athena-community

pip is the easiest way to install the adapter:

python -m pip install dbt-athena-community

Installing dbt-athena-community will also install dbt-core and any other dependencies.

Configuring dbt-athena-community

For Athena-specifc configuration please refer to Athena Configuration

For further info, refer to the GitHub repository: dbt-athena/dbt-athena

Connecting to Athena with dbt-athena

This plugin does not accept any credentials directly. Instead, credentials are determined automatically based on AWS CLI/boto3 conventions and stored login info. You can configure the AWS profile name to use via aws_profile_name. Check out the dbt profile configuration below for details.

~/.dbt/profiles.yml

default:
  outputs:
    dev:
      type: athena
      s3_staging_dir: [s3_staging_dir]
      region_name: [region_name]
      database: [database name]
      schema: [dev_schema]
      aws_profile_name:
        [optional, profile to use from your AWS shared credentials file.]

  target: dev