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 don't 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 are duplicate rows in the primary input source.

The component generates multiple select queries separated by EXCEPT.


Properties

Name = string

A human-readable name for the component.


Cast Types = boolean

Choose whether to cast types.

  • Yes: If the same-named column from both inputs has differing input types, attempt to cast them to a common type. This isn't guaranteed to work. Please check your data carefully before proceding with this.
  • No: If the same-named column from both inputs has differing input types, report an error and halt.

Primary Table = drop-down

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


Snowflake Databricks Amazon Redshift (preview)