When you configure a lookup, you define the behavior when a lookup condition returns more than one match. You can return all rows, any row, the first row, the last row, or an error.
The following configurations have multiple match policy restrictions:
If the multiplicity option is set to Report error, the task does not fail.
When you configure a lookup override without caching, the return first row and return last row multiple matches options are not applicable.
Mappings configured for an uncached lookup and multiple matches fails when the Snowflake source contains case-sensitive tables and column names.