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
andappend
) and Hive tables (insert_overwrite
andappend
).
Not supported yet: Python models, persist docs for views.
0