Skip to content

Except

The Except component lets users compare two input flows (a primary table and a comparison table) and then output any rows from the primary table that do not also exist in the comparison table.

Because an entire row is compared, only overlapping columns are considered. Otherwise, all rows would always look unique and thus be passed on. Only unique rows are passed to the next component if there exist duplicate rows in the primary input source.

Properties

Name = string

A human-readable name for the component.

Types = drop-down

Choose whether to cast types.

  • Yes: if the same-named column from both inputs has differing input types, Matillion ETL attempts to cast them to a common type. This is not guaranteed to work, so please check your data carefully.
  • No: if the same-named column from both inputs has differing input types, Matillion ETL reports an error and will not continue.

Primary Table = drop-down

Select the input source to treat as the primary table. The other input source becomes the secondary (comparison) table.

Strategy

Generates multiple select queries separated by EXCEPT (for snowflake and Amazon Redshift) or LEFT JOIN (for Google BigQuery).

Snowflake Delta Lake on Databricks Amazon Redshift Google BigQuery Azure Synapse Analytics
✅ ✅ ✅ ✅ ✅