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.
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.
Generates multiple select queries separated by EXCEPT (for snowflake and Anazon Redshift) or LEFT JOIN (for Google BigQuery).
|Snowflake||Delta Lake on Databricks||Amazon Redshift||Google BigQuery||Azure Synapse Analytics|