ClickHouse and dbt: Managing the Schema Layer
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.
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.
Visualize roles, grants, and inheritance across a repository, and see which objects are flagged by Atlas's security analyzers.
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.
Manage the Snowflake layer under a dbt project as code: schemas, the bronze landing zone, roles and grants, planned, linted and drift-checked.
Manage Snowflake access control as code with Atlas, account roles, database roles, the role-to-role and role-to-user grant graph, and object GRANTs, all from declarative HCL.