# 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.