Snowflake Connector Guide

Snowflake Connector Guide

Snowflake Targets in Mappings

Snowflake Targets in Mappings

In a mapping, you can configure a target transformation to represent a Snowflake target.
You can write data to an existing table or create a table in the target by using create target option.
You can configure partitioning to optimize the mapping performance at run time when you write data to Snowflake targets. The partition type controls how the agent distributes data among partitions at partition points. You can define the partition type as passthrough partitioning. With partitioning, the agent distributes rows of target data based on the number of threads that you define as partition.
The following table describes the Snowflake target properties that you can configure in a Target transformation:
Property Description
Connection Name of the target connection.
Target Type Type of target object.
Object The target object for the task. Select the target object.
You can either select an existing table or create a new table.
Create Target Creates a target. Enter the table name.
Make sure that the table name is in all caps.
Operation The target operation. Select Insert, Update, Upsert, or Delete.
You cannot use Data Driven operation in Target transformation.
Update columns The temporary key column to update data to or delete data from a Snowflake target.
If you perform an update, update else insert, or delete operation and the Snowflake target does not include a primary key column, click Add to add a temporary key. You can select multiple columns.
The following table describes the advanced properties that you can configure in a Target 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 write operation. For example, if you want to assign sequence object to a primary key field of the target table before you write data to the table, specify a Pre-SQL.
Post SQL SQL statement that is executed after completion of write operation. For example, if you want to alter the table created by using create target option and assign constraints to the table before you write data to the table, specify a Post-SQL.
Batch Row Size Number of rows that the agent writes in a batch to the Snowflake target.
Number of local staging files Enter the number of local staging files. The agent writes data to the target, after the specified number of local staging files are created.
Truncate Target Table Truncates the database target table before inserting new rows. Select one of the following options:
  • True. Truncates the target table before inserting all rows.
  • False. Inserts new rows without truncating the target table
Default is false.
Additional Write Runtime Parameters
Specify additional runtime parameters.
For example:
remoteStage=CQA.CQA_SCHEMA.CQA_STAGE
Separate multiple runtime parameters with &.
Table Name Overrides the table name of the Snowflake target table.
Success File Directory Not supported.
Error File Directory Not supported.
Forward Rejected Rows Determines whether the transformation passes rejected rows to the next transformation or drops rejected rows. By default, the agent forwards rejected rows to the next transformation.

Updated March 07, 2019


Explore Informatica Network