skilld
All skills
dbt-labs avatar

/adding-dbt-unit-test

@9d91941 official
by dbt Labsdbt-labs/dbt-agent-skills729 stars
62

Creates unit test YAML definitions that mock upstream model inputs and validate expected outputs. Use when adding unit tests for a dbt model or practicing test-driven development (TDD) in dbt.

Ask your Agent

Use this Skill: https://skilld.dev/gh/dbt-labs/dbt-agent-skills/adding-dbt-unit-test

This session only. Nothing lands on disk.

referenceswarehouse-redshift-data-types.md

≈174 tokens on demand. Your agent reads this file only when SKILL.md points to it.

Redshift

Platform-specific data type examples:


unit_tests:
  - name: test_my_data_types
    model: fct_data_types
    given:
      - input: ref('stg_data_types')
        rows:
         - int_field: 1
           float_field: 2.0
           str_field: my_string
           str_escaped_field: "my,cool'string"
           date_field: 2020-01-02
           timestamp_field: 2013-11-03 00:00:00-0
           timestamptz_field: 2013-11-03 00:00:00-0
           json_field: '{"bar": "baz", "balance": 7.77, "active": false}'

Currently, the array data type is not supported for YAML format dict inputs. Use the sql format instead if you need to mock array inputs or outputs.

Source: SKILL.md on GitHub

Third-party checks

1 warning17d5 checks · Risk SAFE
  • Gen Agent Trust Hub17d

    The skill provides instructional guidance and reference material for creating dbt unit tests. It does not contain any executable scripts, dependencies, or security risks.

  • Socket17d

    No alerts

  • Snyk17d

    Risk: LOW · No issues

  • Runlayer7mo

    9/14 files flagged

  • ZeroLeaks5mo

    Score: 93/100 · 2 sections analyzed

Provenance

Signed by skilld at 9d91941. This ties the file your Agent reads to that commit on GitHub. It does not review the instructions.

Last checked against GitHub 2 days ago.

Activeupdated 5 months ago

Capability

user-invocable
false
metadata
{
  "author": "dbt-labs"
}

Topics

  • dbt
  • unit-testing
  • sql
  • yaml
  • tdd
  • data-warehouse

README badge

README badge for dbt-labs/dbt-agent-skills/adding-dbt-unit-test

What it does

Creates YAML unit test definitions for dbt SQL models with mocked upstream inputs and expected outputs. Use this when adding unit tests to validate model transformation logic or practicing test-driven development in dbt projects.

Generated from the current SKILL.md.

Frequently asked

What SQL models can I create unit tests for?
You can create unit tests for SQL models only. Python models, snapshots, seeds, sources, analyses, and models using materialized view or recursive SQL materializations are not supported.
Do upstream models need to exist before running unit tests?
Yes. Direct parent models must exist in the warehouse before running unit tests. You can build them schema-only with `dbt run --select +my_model --exclude my_model --empty`, or use `dbt build --select my_model` which handles the full pipeline automatically.
Should I run unit tests in production?
No. dbt Labs recommends running unit tests only in development and CI environments. Use the `--exclude-resource-type` flag or `DBT_EXCLUDE_RESOURCE_TYPES` environment variable to skip them in production builds.
What data formats are supported for mock inputs and outputs?
The default format is `dict` (inline YAML). The skill also supports CSV and SQL formats for fixture data, with SQL required when testing models that depend on ephemeral models.
Can I unit test cross-project models or models from packages?
No. dbt only supports adding unit tests to models in your current project.

Generated from the current SKILL.md. These answers refresh after source changes.