Resources

dbt™ Tests Hub

Search tests

Top searches: AI, dbt Cloud™ pricing, IDE, Bolt

Introduction

dbt™️ tests are SQL-based assertions used to validate data models, sources, and snapshots, ensuring high data quality and integrity. By running dbt™️ test, these tests catch anomalies like nulls, duplicates, or breaking business logic, preventing downstream failures. They include built-in, generic tests (YAML) and custom singular tests (SQL).

We have created a comprehensive database of dbt™️ tests across various packages popular in the dbt™️ community today.

Introduction

We have created a comprehensive database of dbt™️ tests across various packages popular in the dbt™️ community today.

Uniqueness

dbt-utils

not_constant

Values range

dbt-utils

accepted_range

Values set

dbt-core

accepted_values

Anomaly detection

elementary

all_columns_anomalies

Null handling, Volume

dbt-utils

at_least_one

Uniqueness, Tables relationship

dbt-utils

cardinality_equality

Anomaly detection

elementary

column_anomalies

Anomaly detection

elementary

dimension_anomalies

Volume, Tables relationship

dbt-utils

equal_rowcount

Tables relationship

dbt-utils

equality

Anomaly detection, Freshness

elementary

event_freshness_anomalies

Uniqueness

dbt-expectations

expect_column_distinct_count_to_be_greater_than

Uniqueness

dbt-expectations

expect_column_distinct_count_to_be_less_than

Uniqueness

dbt-expectations

expect_column_distinct_count_to_equal

Uniqueness, Tables relationship

dbt-expectations

expect_column_distinct_count_to_equal_other_table

Values set

dbt-expectations

expect_column_distinct_values_to_be_in_set

Values set

dbt-expectations

expect_column_distinct_values_to_contain_set

Values set

dbt-expectations

expect_column_distinct_values_to_equal_set

Values distribution, Values range

dbt-expectations

expect_column_max_to_be_between

Values distribution

dbt-expectations

expect_column_mean_to_be_between

Values distribution

dbt-expectations

expect_column_median_to_be_between

Values distribution, Values range

dbt-expectations

expect_column_min_to_be_between

Values set, Values distribution

dbt-expectations

expect_column_most_common_value_to_be_in_set

Columns relationship

dbt-expectations

expect_column_pair_values_a_to_be_greater_than_b

Columns relationship

dbt-expectations

expect_column_pair_values_to_be_equal

Values set, Columns relationship

dbt-expectations

expect_column_pair_values_to_be_in_set

Uniqueness

dbt-expectations

expect_column_proportion_of_unique_values_to_be_between

Values distribution

dbt-expectations

expect_column_quantile_values_to_be_between

Values distribution

dbt-expectations

expect_column_stdev_to_be_between

Aggregation, Values range

dbt-expectations

expect_column_sum_to_be_between

Schema

dbt-expectations

expect_column_to_exist

Uniqueness

dbt-expectations

expect_column_unique_value_count_to_be_between

Values format

dbt-expectations

expect_column_value_lengths_to_be_between

Values format

dbt-expectations

expect_column_value_lengths_to_equal

Values range

dbt-expectations

expect_column_values_to_be_between

Values distribution

dbt-expectations

expect_column_values_to_be_decreasing

Values set

dbt-expectations

expect_column_values_to_be_in_set

Schema

dbt-expectations

expect_column_values_to_be_in_type_list

Values distribution

dbt-expectations

expect_column_values_to_be_increasing

Null handling

dbt-expectations

expect_column_values_to_be_null

Schema

dbt-expectations

expect_column_values_to_be_of_type

Uniqueness

dbt-expectations

expect_column_values_to_be_unique

Anomaly detection, Values distribution

dbt-expectations

expect_column_values_to_be_within_n_moving_stdevs

Anomaly detection, Values distribution

dbt-expectations

expect_column_values_to_be_within_n_stdevs

Values format

dbt-expectations

expect_column_values_to_have_consistent_casing

Values format

dbt-expectations

expect_column_values_to_match_like_pattern

Values format

dbt-expectations

expect_column_values_to_match_like_pattern_list

Values format

dbt-expectations

expect_column_values_to_match_regex

Values format

dbt-expectations

expect_column_values_to_match_regex_list

Values set

dbt-expectations

expect_column_values_to_not_be_in_set

Null handling

dbt-expectations

expect_column_values_to_not_be_null

Values format

dbt-expectations

expect_column_values_to_not_match_like_pattern

Values format

dbt-expectations

expect_column_values_to_not_match_like_pattern_list

Values format

dbt-expectations

expect_column_values_to_not_match_regex

Values format

dbt-expectations

expect_column_values_to_not_match_regex_list

Uniqueness

dbt-expectations

expect_compound_columns_to_be_unique

Freshness

dbt-expectations

expect_grouped_row_values_to_have_recent_data

Aggregation, Columns relationship

dbt-expectations

expect_multicolumn_sum_to_equal

Completeness, Freshness

dbt-expectations

expect_row_values_to_have_data_for_every_n_datepart

Freshness

dbt-expectations

expect_row_values_to_have_recent_data

Uniqueness

dbt-expectations

expect_select_column_values_to_be_unique_within_record

Aggregation, Tables relationship

dbt-expectations

expect_table_aggregation_to_equal_other_table

Schema

dbt-expectations

expect_table_column_count_to_be_between

Schema

dbt-expectations

expect_table_column_count_to_equal

Schema

dbt-expectations

expect_table_column_count_to_equal_other_table

Schema

dbt-expectations

expect_table_columns_to_contain_set

Schema

dbt-expectations

expect_table_columns_to_match_ordered_list

Schema

dbt-expectations

expect_table_columns_to_match_set

Schema

dbt-expectations

expect_table_columns_to_not_contain_set

Volume

dbt-expectations

expect_table_row_count_to_be_between

Volume

dbt-expectations

expect_table_row_count_to_equal

Volume, Tables relationship

dbt-expectations

expect_table_row_count_to_equal_other_table

Volume, Tables relationship

dbt-expectations

expect_table_row_count_to_equal_other_table_times_factor

Custom logic

dbt-utils

expression_is_true

Volume, Tables relationship

dbt-utils

fewer_rows_than

Anomaly detection, Freshness

elementary

freshness_anomalies

Columns relationship

dbt-utils

mutually_exclusive_ranges

Values set

dbt-utils

not_accepted_values

Values format, Null handling

dbt-utils

not_empty_string

Null handling

dbt-core

not_null

Null handling

dbt-utils

not_null_proportion

Freshness

dbt-utils

recency

Tables relationship

dbt-core

relationships

Tables relationship

dbt-utils

relationships_where

Values distribution

dbt-utils

sequential_values

Uniqueness

dbt-core

unique

Uniqueness

dbt-utils

unique_combination_of_columns

Anomaly detection, Volume

elementary

volume_anomalies

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Experience Analytics for the AI-Era

Start your 14-day trial today - it's free and no credit card needed

Start for free

Platform

Resources

ADD-ONs

Industries

About

Legal

Made with ❤️ in San Francisco ・ London

*dbt® and dbt Core® are federally registered trademarks of dbt Labs, Inc. in the United States and various jurisdictions around the world. Paradime is not a partner of dbt Labs. All rights therein are reserved to dbt Labs. Paradime is not a product or service of or endorsed by dbt Labs, Inc.

Start for free

Platform

Resources