Skip to content

Intersect

The Intersect component compares two input flows, and then outputs any rows that are in common (identical) in both tables.

An entire row is compared, but only overlapping columns are considered, otherwise no rows would look unique. Also, because this component uses the SQL INTERSECT operator, only unique rows are passed to the next component if there are duplicate rows in the source components.

Properties

Name = string

A human-readable name for the component.

Cast 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. 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.

Note

If using Google BigQuery, take care when casting float types into string types as this may introduce numerical inaccuracies.

Strategy

Generates multiple select queries separated by INTERSECT.

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