Skip to main content
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.
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 Database
drop-down
required
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
required
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
required
Select the table containing the values you want to verify against.