Skip to main content
The Assert Table Values test component lets you verify that the data in a specified table matches a fixed set of expected values defined in the component. It checks that all expected columns exist in the target table with matching data types (additional table columns are allowed), then compares all rows against the expected dataset. Any differences are written to another table.
This component is only available in Tests.

​
Properties

​
Name
string
required
A human-readable name for the component.
​
Database
drop-down
required
The Snowflake database that contains the table to verify. The special value [Environment Default] uses the database defined in the environment. Read Database, Schema, and Share DDL to learn more.
​
Schema
drop-down
required
The Snowflake schema that contains the table to verify. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
​
Table
drop-down
required
Select the table whose values you want to verify.
​
Expected Columns
column editor
required
Enter the following details for each table column expected to be present in the table specified in the Table property:
  • Name: The name of the column.
  • Type: The data type of the column. Choose from the available Snowflake data types:
    • VARCHAR: This type is suitable for numbers and letters. A varchar or Variable Character Field is a set of character data of indeterminate length.
    • NUMBER: This type is suitable for numeric types, with or without decimals.
    • FLOAT: This type is suitable for approximate numeric values with fractional components.
    • BOOLEAN: This type is suitable for data that is either “true” or “false”.
    • DATE: This type is suitable for dates without times.
    • TIMESTAMP: This type is suitable for column data values entered as a comma-separated list in the format YYYY-MM-DD HH:MI:SS.
    • TIMESTAMP_NTZ: This type is suitable for column data values entered as a comma-separated list in the format YYYY-MM-DD HH:MI:SS.
    • TIMESTAMP_LTZ: This type is suitable for column data values entered as a comma-separated list in the format YYYY-MM-DD HH:MI:SS.
    • TIMESTAMP_TZ: This type is suitable for column data values entered as a comma-separated list in the format YYYY-MM-DD HH:MI:SS +TZ.
    • TIME: This type is suitable for column data values entered as a comma-separated list in the format HH:MI:SS.
    • VARIANT: This type is suitable for column data values entered as a comma-separated list in JSON format.
  • Size: For VARCHAR types, this is the maximum length. This is a limit on the number of bytes, not characters. For Numeric types, this is the total number of digits allowed, whether before or after the decimal point.
  • Scale: The precision of the data in the column. Will be 0 (zero) for non-applicable types.
Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read Grid variables.
​
Expected Values
column editor
required
Specify the values you expect to find in the table defined in the Table property. A dynamic table of values is generated, with one column for each column defined above.Click the Text mode toggle at the bottom of the dialog to open a multi-line editor that lets you add items in a single block. For more information, read Text mode.To use grid variables, select the Use Grid Variable checkbox at the bottom of the dialog. For more information, read Grid variables.