Assert Components in Matillion ETL

Assert Components in Matillion ETL


Overview

Matillion ETL's suite of Assert components empower users to verify conditions of scalar variables, tables, external tables, and views.

Please Note

  • The Assert components are an Enterprise Mode feature.
  • Assert External Table is not yet available for Matillion ETL for Azure Synapse Analytics.

The Assert components suite includes:

  • Assert Scalar Variables, which lets users verify a variable's value or else halt the running of a job.
  • Assert External Table, which lets users assert the metadata and row count of an external table.
  • Assert Table, which lets users verify that the target table has been created with the correct metadata.
  • Assert View, which lets users verify that certain conditions of a view are true, or else halt the running of a job.