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

Name

string

required

A human-readable name for the component.

Database

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.

Schema

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.

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.

Name

string

required

A human-readable name for the component.

Catalog

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.

Schema (database)

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.

Table

drop-down

required

Select the table whose values you want to verify.

Expected catalog

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.

Expected schema

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.

Expected table

drop-down

required

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

Name

string

required

A human-readable name for the component.

Schema

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.

Table

drop-down

required

Select the table whose values you want to verify.

Expected schema

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.

Expected table

drop-down

required

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

Name

string

required

A human-readable name for the component.

GCP project ID

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.

Dataset

drop-down

required

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

Table

drop-down

required

Select the table whose values you want to verify.

Expected GCP project ID

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.

Expected dataset

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.

Expected table

drop-down

required

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

​Properties

Properties