Templated Expectations

VDA provides a growing repository of out-of-the-box expectations so that users can benefit without the need to create and define their own. These predefined criteria cover a wide range of standard data quality checks and are categorized at both the table and column levels.

Table-Level Expectations:

• Table Row Count to Equal

• Table Row Count to be Between

• Table Column Count to Equal

• Table Column Count to be Between

• Table Column Name to Exist

• Table Column to Match Set

• Table Custom SQL Test

• Table Row Inserted Count to be Between

• Expect table columns to match ordered list

• Expect table row count to be between

• Expect table row count to equal

Column-Level Expectations:

• expect_column_max_to_be_between: Expect the column maximum to be between a minimum and a maximum value.

• expect_column_mean_to_be_between: Expect the column mean to be between a minimum and a maximum value (inclusive).

• expect_column_median_to_be_between: Expect the column median to be between a minimum and a maximum value.

• expect_column_min_to_be_between: Expect the column minimum to be between a minimum value and a maximum value.

• expect_column_values_to_be_in_set: Expect each column value to be in a given set.

• expect_column_values_to_be_in_type_list: Expect a column to contain values from a specified type list.

• expect_column_values_to_be_null: Expect the column values to be null.

• expect_column_values_to_be_of_type: Expect a column to contain values of a specified data type.

• expect_column_values_to_be_unique: Expect each column value to be unique.

• expect_column_values_to_not_be_null: Expect the column values to not be null.

These templated expectations help streamline data quality assurance processes, ensuring users can quickly and effectively apply industry-standard checks to their data assets.