docs.getdbt.com

Define dbt sources with freshness tests and configure source freshness alerting in a CI pipeline

Write dbt generic tests (unique, not_null, relationships, accepted_values) and add custom singular tests for complex data quality rules

Configure dbt materializations (table, view, incremental, ephemeral) and choose the right one per model

Use dbt macros to encapsulate reusable SQL logic and call them across multiple models

Configure dbt model-level and project-level grants to manage warehouse access control alongside dbt materializations

Implement dbt exposures to document and track downstream BI dashboards and data consumers dependent on dbt models

Configure dbt snapshots with SCD Type 2 using check_cols strategy to track changes in specific columns

Use dbt state:modified selector and slim CI to run only changed models and their downstream dependents in pull request pipelines

Configure dbt build to run models, tests, snapshots, and seeds in DAG order with selective execution

Implement dbt microbatch incremental models for event-stream tables with sub-daily refresh cadence

Define and enforce dbt model contracts with column-level data type and constraints

Write dbt unit tests to validate SQL transformation logic without running against warehouse data

Version a dbt model using the model versioning API to manage breaking schema changes

Configure dbt model deferral and state:modified to speed up CI runs against a production manifest

Define a dbt exposure to document and govern BI tool and downstream system dependencies on dbt models

Define a MetricFlow semantic model in YAML with primary, foreign, and unique entity types to enable automatic join resolution

Configure a MetricFlow time spine in YAML (dbt v1.9+ format) to support time-series metric queries

Author a MetricFlow conversion metric in YAML to track funnel conversion rates between two events

Define a MetricFlow derived metric with a time offset to compute period-over-period growth

Create a MetricFlow ratio metric in YAML to express a rate such as click-through rate from two existing measures

Connect a BI tool to the dbt Semantic Layer via the JDBC (ArrowFlight SQL) API using a service token

Query dbt Semantic Layer metric history using the GraphQL queryRecords endpoint

Define a saved query in dbt MetricFlow YAML to standardize a commonly used metric + dimension combination for BI tool consumption

Configure dbt Cloud Semantic Layer access control by mapping service tokens to separate warehouse credentials for different teams

Add dbt Semantic Layer validation to a CI pipeline using the dbt sl validate command

Query the dbt Cloud Semantic Layer GraphQL API to retrieve metric values with dimension breakdowns

Trigger a dbt Cloud job run via the REST API and download run artifacts on completion

Create and automate a dbt Cloud environment with CI job runs triggered on pull requests via the API

Choose and configure dbt incremental strategies: merge, insert_overwrite, and microbatch for different workloads

Implement dbt snapshots to track slowly changing dimensions (SCD Type 2) with full history

dbt Cloud API trigger job run and poll status