Skip to main content

Athena Profile

Overview of dbt-athena

Maintained by: Community Author: Tomme Source: Github dbt Cloud: Not Supported
dbt Slack channel Link to channel

The easiest way to install is to use pip:

pip install git+https://github.com/Tomme/dbt-athena.git

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. Checkout 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