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, Designer 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, Designer reports an error and will not continue.

Strategy

Generates multiple select queries separated by INTERSECT.

Snowflake Databricks Amazon Redshift
✅ ❌ ✅