Snowflake Connector Guide

Snowflake Connector Guide

Snowflake Sources in Mappings

Snowflake Sources in Mappings

In a mapping, you can configure a source transformation to represent a Snowflake source.
You can configure partitioning to optimize the mapping performance at run time when you read data from Snowflake. The partition type controls how the agent distributes data among partitions at partition points. You can define the partition type as key range partitioning. With partitioning, the agent distributes rows of source data based on the number of threads that you define as partition.
The following table describes the Snowflake source properties that you can configure in a Source transformation:
Property Description
Connection Name of the source connection.
Source Type Type of the source object. Select Single Object, Multiple Objects, Query, or Parameter.
When you use a custom SQL query to import Snowflake tables, the Secure Agent fetches the metadata using separate metadata calls.
Object The source object for the task. Select the source object for a single source. When you select the multiple source option, you can add source objects and configure relationship between them.
Filter Filters records based on the filter condition. Configure a simple filter.
Sort Sorts records based on the conditions you specify. You can specify the following sort conditions:
  • Not parameterized. Select the fields and type of sorting to use.
  • Parameterized. Use a parameter to specify the sort option.
The following table describes the advanced properties that you can configure in a Source 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 SQL statement that is executed prior to start of a read operation. For example, if you want to update records in the database before you read the records from the table, specify a Pre-SQL statement.
Post SQL SQL statement that is executed after completion of a read operation. For example, if you want to delete some records after the latest records load, specify a Post-SQL statement.
Table Name Overrides the table name of the imported Snowflake source table.
SQL Override The SQL statement to override the default query used to read data from the Snowflake source.
Tracing Level Determines the amount of detail that appears in the log file. You can select Terse, Normal, Verbose Initialization, or Verbose Data. Default value is Normal.

Updated August 12, 2019


Explore Informatica Network