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


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://docs.vdalive.com/how-to-guides/data-quality/expectations/templated-expectations.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.
