dbt-best-practices

What problem does it solve?

dbt projects often suffer from drift, inconsistent structure, and missing tests, making maintenance and scaling difficult across teams.

Core Features & Use Cases

• Layer Organization (CRITICAL): Staging, Intermediate, and Marts layers with clear responsibilities.
• Materialization Strategy: guidelines for view/ephemeral/table usage per layer to balance freshness and cost.
• Naming Conventions: consistent prefixes like stg_, int_, fct_, dim_ for models and artifacts.
• Incremental Models: recommended use of incremental models with unique keys and merge strategies.
• Testing & Documentation: enforce schema tests, freshness checks, and dbt docs generation.

Quick Start

Set up your dbt project to follow the Layer Organization (Staging, Intermediate, Marts), implement the naming conventions, and apply the recommended tests and documentation.