calogica/dbt-expectations

Health v2 · maintenance only

Adoption not part of the score

1232 stars · 166 forks observed · 2026-10-09

What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded

A dbt extension package that ports Great Expectations-style data quality tests as dbt test macros. It lets data teams run expectation tests (column existence, recency, value ranges, schema comparisons) directly in their warehouse via dbt.

Use cases

• add great expectations style tests to dbt models
• validate data quality in snowflake or bigquery from dbt
• assert table columns and row counts in dbt tests
• check for recent data in warehouse tables
• compare table schemas and aggregations across tables
• run data expectation tests without a separate GE integration

When to choose

• you already use dbt and want declarative data quality tests in SQL
• you want Great Expectations-like assertions without deploying a separate GE stack
• your warehouse is Postgres, Snowflake, BigQuery, DuckDB, Spark, or Trino

When to avoid

• you need a standalone data quality framework outside dbt
• you need actively developed features - the package is no longer actively supported
• you use a warehouse or dbt version outside the supported matrix

Facets

library · maturity maintenance

testing data-science etl databases analytics testing python cloud dbt data-quality great-expectations sql data-warehouse data-tests data-engineering postgres

Member repositories

For agents

markdown · JSON · MCP: product_card(name="calogica/dbt-expectations")