PowerExchange for Snowflake User Guide

10.5.6
- 10.5.4
- 10.5
- 10.4.1
- 10.4.0

Back Next

Snowflake Data Object Write Operation Properties

Snowflake data object write operation properties include run-time properties that apply to the Snowflake data object.

The Developer tool displays advanced properties for the Snowflake data object operation in the Advanced view.

The following table describes the Advanced properties for a Snowflake data object write operation:

Property	Description
UpdateMode	Loads data to the target based on the mode you specify. Select one of the following modes: Update As Update. Updates all rows flagged for update. Update Else Insert. Updates all rows flagged for update if they exist in the target and then inserts any remaining rows marked for insert.
Database	Overrides the database name specified in the connection.
Schema	Overrides the schema name specified in the connection.
Warehouse	Overrides the Snowflake warehouse name specified in the connection.
Role	Overrides the Snowflake user role specified in the connection.
Pre SQL	SQL statement that the Data Integration Service executes before extracting data from the source. For example, if you want to assign sequence object to a primary key field of the target table before you load data to the table, specify a pre-SQL.
Post SQL	SQL statement that the Data Integration Service executes after extracting data from the source. For example, if you want to alter the table created by using create target option and assign constraints to the table before you load data to the table, specify a post-SQL.
Batch Row Size	The number of rows that the Data Integration Service writes to a file. When the number of rows written to the file reaches the value specified, the Data Integration Service flushes the data queue and starts processing the write commands
Number of local staging files	The number of files that represents a single batch of data. The default number of files is 64. After the Data Integration Service uploads the specified number of local staging files to the Snowflake user stage, Snowflake unloads the data to the target table.
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, if you want to specify the user-defined stage in the Snowflake database to upload the local staging files, specify the name of the stage location in the following format: remoteStage=REMOTE_STAGE If you want to optimize the write performance, you can choose to compress files before writing to Snowflake tables. You can set the compression parameter to On or Off, for example: Compression=On By default, compression is on. Separate multiple runtime parameters with &.
Table Name	Overrides the table name of the Snowflake target table.
Rejected File Path	The filename and path of the file where the Data Integration Service writes rejected records. For example, \rejectedfiles\reject7 Applicable only in the native environment.
Target Schema Strategy	Target schema strategy for the Snowflake target table. You can select one of the following target schema strategies: RETAIN - Retain an existing target schema. CREATE - Create a target if it does not exist. To use the CREATE option, you must provide the value of the database and schema name property in the Snowflake connection. Assign Parameter.