Compare Table Values - Maia Documentation

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

Snowflake
Databricks
Amazon Redshift
Google BigQuery

string

required

A human-readable name for the component.

drop-down

required

The Snowflake database. The special value [Environment Default] uses the database defined in the environment. Read Databases, Tables and Views - Overview to learn more.

drop-down

required

The Snowflake schema. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.

drop-down

required

Select the table whose values you want to verify.

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.

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.

drop-down

required

Select the table containing the values you want to verify against.

string

required

A human-readable name for the component.

drop-down

required

Select a Databricks Unity Catalog. The special value [Environment Default] uses the catalog defined in the environment. Selecting a catalog will determine which databases are available in the next parameter.

drop-down

required

The Databricks schema. The special value [Environment Default] uses the schema defined in the environment. Read Create and manage schemas to learn more.

drop-down

required

Select the table whose values you want to verify.

drop-down

required

Select a Databricks Unity Catalog that contains the expected table to verify against. The special value [Environment Default] uses the catalog defined in the environment. Selecting a catalog will determine which schemas are available in the next parameter.

drop-down

required

The Databricks schema that contains the expected table to verify against. The special value [Environment Default] uses the schema defined in the environment. Read Create and manage schemas to learn more.

drop-down

required

Select the table containing the values you want to verify against.

string

required

A human-readable name for the component.

drop-down

required

Select the table schema. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.

drop-down

required

Select the table whose values you want to verify.

drop-down

required

The Amazon Redshift schema that contains the expected table to verify against. The special value [Environment Default] uses the schema defined in the environment. For more information on using multiple schemas, read Schemas.

drop-down

required

Select the table containing the values you want to verify against.

string

required

A human-readable name for the component.

drop-down

required

The Google Cloud project that owns the BigQuery dataset. The special value [Environment Default] uses the Google Cloud project defined in the environment. For more information, read Creating projects.

drop-down

required

The Google BigQuery dataset containing the table to query. The special value [Environment Default] uses the dataset defined in the environment.

drop-down

required

Select the table whose values you want to verify.

drop-down

required

The Google Cloud project that owns the BigQuery dataset containing the expected table to verify against. The special value [Environment Default] uses the Google Cloud project defined in the environment. For more information, read Creating projects.

drop-down

required

The Google BigQuery dataset that contains the expected table to verify against. The special value [Environment Default] uses the dataset defined in the environment.

drop-down

required

Select the table containing the values you want to verify against.

​Properties

Properties