Snowflake Connector Guide

Snowflake Connector Guide

Snowflake Lookups in Mappings

Snowflake Lookups in Mappings

You can create lookups for objects in Snowflake connection. You can retrieve data from a Snowflake lookup object based on the specified lookup condition.
When you configure a lookup in Snowflake, you select the lookup connection and lookup object. You also define the behavior when a lookup condition returns more than one match.
The following table describes the Snowflake lookup object properties that you can configure in a Lookup transformation:
Property Description
Connection Name of the lookup connection.
Source Type Type of the source object. Select Single Object or Parameter.
Lookup Object Name of the lookup object for the mapping.
Multiple Matches Behavior when the lookup condition returns multiple matches. Select Return any row, Return all rows, or Report error.
Filter Not supported.
Sort Not supported.
The following table describes the Snowflake lookup object advanced properties that you can configure in a Lookup transformation:
Advanced Property Description
Database Overrides the database specified in the connection.
Schema Overrides the schema specified in the connection.
Warehouse Overrides the Snowflake warehouse name specified in the connection.
Role Overrides the Snowflake role assigned to user specified in the connection.
Pre SQL Not supported.
Post SQL Not supported.


Updated November 07, 2019


Explore Informatica Network