Internal documentation

This feature is currently for internal use only. This documentation page must only be shared within Matillion.

Assert Table Values🔗

Internal only

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.

Note

This component is only available in Tests.

Properties🔗

Snowflake

Name = string

A human-readable name for the component.

Database = drop-down

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

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

Select the table whose values you want to verify.

Expected Columns = column editor

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

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.

Snowflake	Databricks	Amazon Redshift
✅	❌	❌