Skip to main content

Athena setup

Overview of dbt-athena-adapter

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

Installing dbt-athena-adapter

pip is the easiest way to install the adapter:

pip install dbt-athena-adapter

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

Configuring dbt-athena-adapter

For Athena-specifc configuration please refer to Athena Configuration

For further info, refer to the GitHub repository: Tomme/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
0