---
id: dbt-athena
version: "1.11.0"
license: unclear
license_treatment: permissive
maintenance: active
---

# dbt-athena — The athena adapter plugin for dbt (data build tool)

License: permissive · Maintenance: active · Downloads: 1.2M/mo

## What it is and what it does

dbt-athena is a plugin that connects dbt to Amazon Athena, allowing data engineers to write SQL and Python transformations that execute in Athena. It handles the translation of dbt's model definitions, incremental logic, and snapshots into Athena-compatible DDL and DML, managing query execution, result polling, and metadata updates through boto3 and pyathena.

The adapter supports both Hive and Iceberg table formats, with Iceberg requiring Athena Engine v3 and a unique table location. It integrates with AWS Glue for metadata management, supports incremental models with different merge strategies depending on table type, and can run Python models through Athena Spark workgroups. Configuration is handled through dbt profiles, with options for S3 staging directories, retry policies, workgroup selection, and AWS Lake Formation tagging.

Use it for:

- Build incremental fact tables in Athena using dbt's merge or append strategies, with automatic query retry and state management.
- Create snapshots of slowly-changing dimensions in Athena using timestamp or check strategies for historical tracking.
- Run Python-based data transformations in Athena via Spark workgroups, integrated into a dbt DAG.
- Manage Iceberg table format in Athena with dbt's table materialization and incremental model support.
- Organize raw S3 data into Athena databases with dbt seeds and models, leveraging Glue catalog integration.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

dbt-athena is a dbt adapter that enables data transformation workflows to run against Amazon Athena, supporting table and incremental models, snapshots, and Python models on Hive and Iceberg table formats.

Yes. dbt-athena is actively maintained, has low install friction, supports current Python versions (3.10–3.13), carries no known vulnerabilities, and uses a permissive license. It is the standard way to integrate dbt workflows with Athena. Install it if you use dbt and need to transform data in Athena.

## Install

pip install dbt-athena
uv add dbt-athena
poetry add dbt-athena

## Installing dbt-athena

Before you install: Low install friction; pure Python wheel with 9 runtime dependencies. Actively maintained with a release 29 days ago and recent commits. Supports Python 3.10 through 3.13.

License in practice: Permissive license treatment allows use in commercial and proprietary projects without restriction.

Quickstart:

pip install dbt-athena

In profiles.yml:
athena:
  target: dev
  outputs:
    dev:
      type: athena
      schema: my_schema
      database: awsdatacatalog
      region_name: us-west-2
      s3_staging_dir: s3://my-bucket/dbt/

Requires AWS credentials (via aws cli, boto3 conventions, or explicit keys) and an existing S3 bucket and Athena database.

Verify before relying:

- Whether dbt version 1.7.* constraint applies to all use cases or only specific features.
- Performance characteristics for large-scale incremental models on Hive vs. Iceberg tables.
- Compatibility with dbt Cloud beyond dbt Core.

## Package facts

- License: not declared (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 1.2M/month (top 5,000 on PyPI)
- Known vulnerabilities: none known

## Tags

dbt adapter for athena, amazon athena data transformation, dbt athena integration, transform data in athena, dbt incremental models athena, athena iceberg tables dbt, data build tool athena, dbt-adapter, aws-athena, data-transformation

[View on SkillFed](https://skillfed.io/packages/dbt-athena) · [View on PyPI](https://pypi.org/project/dbt-athena/)