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:
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
0