What is dbt-athena?

dbt-athena is a community-owned adapter for dbt Core. The dbt-athena package contains all the code to enable dbt to work with AWS Athena and transform data using SQL.

In essence, the dbt-athena adapter will transform existing data in Athena by leveraging the CREATE TABLE AS or CREATE VIEW SQL queries in AWS Athena.

Features of dbt-athena

• ✅ Supports dbt version 1.6.*
• ✅ Supports dbt seeds
• ✅ Supports dbt snapshots
• ✅ Supports table materialization using Hive tables (Athena v2/v3) and Iceberg tables (Athena v3)
• ✅ Supports incremental models for Iceberg (merge and append) and Hive tables (insert_overwrite and append).

Not supported yet: Python models, persist docs for views.