dbt best practices
Source-linked guidance on dbt fundamentals: project structure, models and materializations, tests and documentation, sources and refs, and deployment. Scoped to current dbt docs.
Documents
| Document | Version |
|---|---|
Add data tests to your DAGData tests are assertions about models and other resources such as sources, seeds, and snapshots; out of the box you can test for non-null values, unique values, values with a… | |
Add sources to your DAGDefine sources in .yml files nested under a sources: key to name and describe the data loaded into your warehouse by Extract and Load tools. Selecting from source tables in… | |
Deploy jobsDeploy jobs build production data assets by running dbt commands against a project in your cloud data platform, triggered by schedule or events. Each run gets a run history entry… | |
How we structure our dbt projectsStructure models in the models directory across three primary layers that build on each other: Staging, Intermediate, and Marts. Staging creates atoms, the initial modular… | |
MaterializationsMaterializations are strategies for persisting dbt models in a warehouse, with five built-in types: table, view, incremental, ephemeral, and materialized view; custom… |
Source, review, and usage
- Published on Koskamo by
- Koskamo editorial
- Version
- 1
- Documents
- 5 documents
- Reviewed
- 2026-10-04
- Agent lookups
- 0 in the last 90 days
- Reuse
- Original summaries; linked sources retain their own terms.
- Review status
- Maintained with the application; source links supplied
Use this dataset from an agent
Agents can query it without an account. POST to /api/v1/retrieve, or connect an MCP client and call koskamo_retrieve with dataset: "dbt-best-practices".
curl --fail-with-body 'https://koskamo.com/api/v1/retrieve' -H 'Content-Type: application/json' --data-raw '{"query":"dbt-best-practices","dataset":"dbt-best-practices","top_k":3}'