Matillion ETL Shared Job
Author: Matillion
Date Posted: Dec 4, 2023
Last Modified: Dec 4, 2023
Author: Matillion
Date Posted: Dec 4, 2023
Last Modified: Dec 4, 2023
Assert Row Counts
Assert that the row counts of table(s) match expectations.
This shared job loops through the grid variable supplied and uses a Matillion ETL Assert Table component internally to verify the row counts.
Parameters
| Parameter | Description |
|---|---|
| Database | Name of source Database. Set to ${environment_database} to use the environment default |
| Schema | Name of source Schema. Set to ${environment_default_schema} to use the environment default |
| Table exists | Set to Yes to check that the table exists |
| Comparison Type | Choose Equal to, Greater than or equal to or Less than or equal to |
| Tables | A grid variable with two columns: table_name and row_count (numeric) |
Prerequisites
Assertions only work on tables: not views.
Downloads
Licensed under: Matillion Free Subscription License
- Download METL-aws-rs-1.68.3-assert-row-counts.melt
- Platform: AWS
- Target: Redshift
- Version: 1.68.3 or higher
- Download METL-az-sy-1.68.3-assert-row-counts.melt
- Platform: Azure
- Target: Synapse
- Version: 1.68.3 or higher
- Download METL-gcp-bq-1.68.3-assert-row-counts.melt
- Platform: GCP
- Target: BigQuery
- Version: 1.68.3 or higher
- Download METL-sf-1.68.3-assert-row-counts.melt
- Target: Snowflake
- Version: 1.68.3 or higher