dbt

Specific best practices and architectural patterns when working with dbt.

Language / Topic

SQL

Rules

dbt · balanced balanced

- Define analytical data modules inherently isolating identical standard `SELECT` blocks natively creating robust relational views.

- Reference external dynamic variables natively extracting references utilizing the explicitly standard `{{ ref('model_name') }}` compiler natively.

- Extract raw database configurations cleanly configuring specifically standard `sources.yml` definitions replacing cryptic hardcoded tables.

- Verify data quality continuously evaluating exact declarative `tests` schemas mapping `not_null` uniquely onto specific columns.