Internal documentation
This feature is currently for internal use only. This documentation page must only be shared within Matillion.
Compare Table Values🔗
Internal only
The Compare Table Values test component lets you verify that the data in a specified table matches another table. 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🔗
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 Database = drop-down
The Snowflake database that contains the expected table to verify against. The special value [Environment Default] uses the database defined in the environment. Read Database, Schema, and Share DDL to learn more.
Expected Schema = drop-down
The Snowflake schema that contains the expected table to verify against. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Expected Table = drop-down
Select the table containing the values you want to verify against.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ✅ | ❌ | ❌ |