Koskamo

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

Showing 1–5 of 5 documents

DocumentVersion

Add data tests to your DAG

Data 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…

v1

Add sources to your DAG

Define 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…

v1

Deploy jobs

Deploy 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…

v1

How we structure our dbt projects

Structure models in the models directory across three primary layers that build on each other: Staging, Intermediate, and Marts. Staging creates atoms, the initial modular…

v1

Materializations

Materializations are strategies for persisting dbt models in a warehouse, with five built-in types: table, view, incremental, ephemeral, and materialized view; custom…

v1

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

Original sources are linked on each document. Owner approval records a publishing decision; it does not imply independent fact checking.

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".

The JSON endpoint returns document text and source links in pages. Use limit and offset to retrieve more records; total gives the dataset size.

retrieve request
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}'

Change history

This dataset is maintained with the application. Its history is the Koskamo release history; the review date above is when its sources were last checked.