---
title: tableTest
slug: /main-concepts/metadata-standard/schemas/tests/tabletest
---

# TableTest

*TableTest is a test definition to capture data quality tests against tables and columns.*

## Properties

- **`id`**: Unique identifier of this table instance. Refer to *../type/basic.json#/definitions/uuid*.
- **`name`**: Name that identifies this test case. Refer to *../type/basic.json#/definitions/entityName*.
- **`description`**: Description of the testcase. Refer to *../type/basic.json#/definitions/markdown*.
- **`testCase`**: Refer to *#/definitions/tableTestCase*.
- **`executionFrequency`**: Refer to *./basic.json#/definitions/testCaseExecutionFrequency*.
- **`results`** *(array)*: List of results of the test case.
  - **Items**: Refer to *./basic.json#/definitions/testCaseResult*.
- **`owner`**: Owner of this Pipeline. Refer to *../type/entityReference.json*. Default: `None`.
- **`updatedAt`**: Last update time corresponding to the new version of the entity in Unix epoch time milliseconds. Refer to *../type/basic.json#/definitions/timestamp*.
- **`updatedBy`** *(string)*: User who made the update.
## Definitions

- **`tableTestCase`** *(object)*: Table Test Case. Cannot contain additional properties.
  - **`config`**
  - **`tableTestType`**: Must be one of: `['tableRowCountToEqual', 'tableRowCountToBeBetween', 'tableColumnCountToEqual', 'tableColumnCountToBeBetween', 'tableColumnToMatchSet', 'tableColumnNameToExist', 'tableCustomSQLQuery']`.


Documentation file automatically generated at 2022-07-14 10:51:34.749986.