Matillion ETL Shared Job

Assert that the row counts of table(s) match expectations.

Assert Row Counts

This shared job loops through the grid variable supplied and uses a Matillion ETL Assert Table component internally to verify the row counts.


DatabaseName of source Database. Set to ${environment_database} to use the environment default
SchemaName of source Schema. Set to ${environment_default_schema} to use the environment default
Table existsSet to Yes to check that the table exists
Comparison TypeChoose Equal to, Greater than or equal to or Less than or equal to
TablesA grid variable with two columns: table_name and row_count (numeric)


Assertions only work on tables: not views.


Licensed under: Matillion Free Subscription License

Download METL-aws-rs-1.68.3-assert-row-counts.melt

Download METL-az-sy-1.68.3-assert-row-counts.melt

Download METL-gcp-bq-1.68.3-assert-row-counts.melt

Download METL-sf-1.68.3-assert-row-counts.melt

Installation instructions

How to Install a Matillion ETL Shared Job

Author: Matillion