dbt-expectations | Port of Great Expectations to dbt test macros

Expect the specified column to exist. Expect the model to have rows that are at least as recent as the defined interval prior to the current timestamp. Optionally gives the possibility to apply filters on the results. Expect the model to have grouped rows that are at least as recent as the defined interval prior to the current timestamp. Use this to test whether there is recent data for each grouped row defined by group_by (which is a list of columns) and a timestamp_column. Optionally gives the possibility to apply filters on the results. Applies to: Model, Seed, Source. Expect the number of columns in a model to be between two values. Applies to: Model, Seed, Source. Expect the number of columns in a model to match another model. Applies to: Model, Seed, Source. Expect the columns in a model to contain a given list. Applies to: Model, Seed, Source. Expect the number of columns in a model to be equal to expected_number_of_columns. Applies to: Model, Seed, Source. Expect the columns to exactly match a specified list. Applies to: Model, Seed, Source. Expect the columns in a model to match a given list. Applies to: Model, Seed, Source. Expect the number of rows in a model to be between two values. Applies to: Model, Seed, Source. Expect the number of rows in a model match another model. Applies to: Model, Seed, Source. Expect the number of rows in a model to match another model times a preconfigured factor. Applies to: Model, Seed, Source. Expect the number of rows in a model to be equal to expected_number_of_rows. Applies to: Model, Seed, Source. Expect each column value to be unique. Expect column values to not be null. Expect column values to be null. Expect a column to be of a specified data type. Expect a column to be one of a specified type list. Expect each column value to be in a given set. Expect each column value to be between two values. Expect each column value not to be in a given set. Expect column values to be increasing. If strictly: True, then this expectation is only satisfied if each consecutive value is strictly increasing–equal values are treated as failures. Expect column values to be decreasing. If strictly=True, then this expectation is only satisfied if each consecutive value is strictly increasing–equal values are treated as failures. Expect column entries to be strings with length between a min_value value and a max_value value (inclusive). Expect column entries to be strings with length equal to the provided value. Expect column entries to be strings that match a given regular expression. Valid matches can be found anywhere in the string, for example "[at]+" will identify the following strings as expected: "cat", "hat", "aa", "a", and "t", and the following strings as unexpected: "fish", "dog". Expect column entries to be strings that do NOT match a given regular expression. The regex must not match any portion of the provided string. For example, "[at]+" would identify the following strings as expected: "fish”, "dog”, and the following as unexpected: "cat”, "hat”. Expect the column entries to be strings that can be matched to either any of or all of a list of regular expressions. Matches can be anywhere in the string. Expect the column entries to be strings that do not match any of a list of regular expressions. Matches can be anywhere in the string. Expect column entries to be strings that match a given SQL like pattern. Expect column entries to be strings that do not match a given SQL like pattern. Expect the column entries to be strings that match any of a list of SQL like patterns. Expect the column entries to be strings that do not match any of a list of SQL like patterns. Expect the number of distinct column values to be equal to a given value. Expect the number of distinct column values to be greater than a given value. Expect the set of distinct column values to be contained by a given set. Expect the set of distinct column values to contain a given set. In contrast to expect_column_values_to_be_in_set this ensures not that all column values are members of the given set but that values from the set must be present in the column. Expect the set of distinct column values to equal a given set. In contrast to expect_column_distinct_values_to_contain_set this ensures not only that a certain set of values are present in the column but that these and only these values are present. Expect the number of distinct column values to be equal to number of distinct values in another model. Applies to: Model, Column, Seed, Source.