dbt-labs/dbt-utils
Utility functions for dbt projects. observed · 2026-08-28
Health v2 · maintenance only
92/100
- Activity 91
- Release rhythm 90
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-03. Adoption (stars, forks) is never an input.
- gap_med: 21.5
- age_days: 3335
- days_rel: 66
- days_push: 57
- n_releases_24m: 9
Adoption not part of the score
1792 stars · 628 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
dbt-utils is an official dbt package providing reusable Jinja macros and generic data tests for dbt projects. It includes SQL generators (date spine, pivot, surrogate keys), introspective macros, and schema tests like equality, recency, and uniqueness checks.
Use cases
- add reusable data quality tests to my dbt project
- generate a date spine table in SQL
- pivot and unpivot columns in a warehouse
- generate surrogate keys in dbt models
- union multiple relations with different columns
- deduplicate rows in a dbt model
- check row counts match between two tables
When to choose
- you use dbt and want battle-tested macros instead of writing your own
- you need common generic tests like recency, equality, or not-null proportion
- you want portable SQL helpers that work across warehouses
When to avoid
- you don't use dbt for data transformation
- you need highly custom logic not covered by the provided macros
- your project requires dbt versions outside the supported range
Facets
library · maturity stable
testing developer-tools etl data-science analytics developer-tools databases python cli cross-platform dbt sql-macros analytics-engineering data-quality-tests jinja sql-generators package-hub data-engineering
7 sources
- readme: https://github.com/dbt-labs/dbt-utils · fetched 2026-08-28 · 481bde74f3e2
- homepage: https://hub.getdbt.com/dbt-labs/dbt_utils/latest/ · fetched 2026-08-29 · d26b04b2893a
- site_page: https://docs.getdbt.com/docs/building-a-dbt-project/package-management · fetched 2026-08-29 · 1ef4e5227932
- site_page: https://docs.getdbt.com/guides/fusion-package-compat · fetched 2026-08-29 · f4db30365c03
- site_page: https://docs.getdbt.com/docs/package-management · fetched 2026-08-29 · 1ef4e5227932
- site_page: https://www.getdbt.com/dbt-labs/about-us · fetched 2026-08-29 · 26494b1195ab
- site_page: https://www.getdbt.com/ · fetched 2026-08-29 · c7654b34b0de
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| dbt-labs/dbt-utils | main | 92 |
For agents
markdown · JSON · MCP: product_card(name="dbt-labs/dbt-utils")
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem