Snowflake Data Cloud Connector

Back Next

Write runtime parameters

You can customize and set any additional runtime parameters when you write to Snowflake.

If you specify more than one additional write runtime parameter, separate each key-value pair with an ampersand (&).

You can configure the following properties as additional write runtime parameters in the Target transformation:

To optimize the write performance, you can choose to compress files before writing to Snowflake tables. You can set the compression parameter to

Off

. By default, compression is on.

For example, if don't want to compress files before you write to Snowflake tables, enter the additional parameter in the following format:

Compression=Off

To replace values specified in fields and write them as Null values to a target, enter the additional parameter in the following format:

null_if=('Field value1','Field value2','Field value3','...')

When you specify more than one field value, separate each field value with a comma (,).

This parameter doesn't apply to mappings in advanced mode.

To trim the leading and trailing white spaces from strings when you write to a target, enter the additional parameter in the following format:

trim_space=true

This parameter doesn't apply to mappings in advanced mode.

You can't trim spaces from strings in the following scenarios:

When strings are enclosed with double quotes.

When you enable the staging property for the write operation.

For more information about these additional parameters, see Copy into table in the Snowflake documentation.