A single hub for all dbt tests

Asserts that a column's values fall inside an expected range. Any combination of min_value and max_value is allowed, and the range can be inclusive or exclusive.

Ensures that a column's values are within a predefined set of acceptable values.

Executes column-level monitors and anomaly detection on all columns of the table, checking data type of each column and executing relevant monitors. Excludes columns based on exclude_prefix/exclude_regexp.

Asserts that a column has at least one value.

Asserts that values in a given column have exactly the same cardinality as values from a different column in a different model.

Executes column-level monitors and anomaly detection on a specific column, checking the data type of the column and executing relevant monitors.

Monitors the frequency of values in configured dimensions over time, alerting on unexpected changes in distribution. Best configured on low-cardinality fields.

Asserts the equality of two relations. Optionally specify a subset of columns to compare.

Monitors the freshness of event data over time, focusing on the expected time it takes each event to load by measuring the difference between the event timestamp and when it is loaded to the database.

Asserts that a valid SQL expression is true for all records. Useful for checking integrity across columns, verifying outcomes based on algebraic operations, verifying column length, or the truth value of a column.

Asserts that the respective model has fewer rows than the model being compared.

Monitors the freshness of your table over time, comparing the freshness of each bucket within the detection period to the freshness of previous time buckets.

Asserts that for a given lower_bound_column and upper_bound_column, the ranges between the lower and upper bounds do not overlap with the ranges of another row.

Asserts that there are no rows that match the given values.

Asserts that a column does not have the same value in all rows.

Asserts that a column does not have any values equal to ''. An optional argument trim_whitespace controls whether whitespace should be trimmed from the column when evaluating.

Ensures that the specified column does not contain any null values.

Asserts that the proportion of non-null values present in a column is between a specified range [at_least, at_most] where at_most is an optional argument (default: 1.0).

Asserts that a timestamp column in the reference model contains data that is at least as recent as the defined date interval.

Verifies the referential integrity between a child and a parent table, typically ensuring foreign key constraints.