Atlas vs dbt: Different Jobs, Better Together
dbt and Atlas are not competing tools: dbt transforms data inside your schemas, Atlas manages the schema layer dbt sits on. What each one does with the same change, demonstrated on ClickHouse.
dbt and Atlas are not competing tools: dbt transforms data inside your schemas, Atlas manages the schema layer dbt sits on. What each one does with the same change, demonstrated on ClickHouse.
ClickHouse-specific decisions for a dbt project: MergeTree engine and ORDER BY on source tables, why changing ORDER BY rebuilds the table, schema-scope grants for dbt, and dimension data as code.
Detect when a warehouse stops matching its checked-in schema while dbt keeps rebuilding models: what migrate status misses, how atlas schema diff reports drift, and what excluding dbt's database costs you.
Which ALTER statements rewrite data on a large warehouse table, which ones are metadata-only, and how to block a destructive change with Atlas lint and a pre-migration check.
Manage the schema layer a dbt project runs on with Atlas: databases, source tables, lookup data, roles and grants, with dbt's own models left to dbt through exclude patterns in atlas.hcl.