Configure the Advanced settings of the
tSnowflakeOutputBulk and
tSnowflakeBulkExec components to use the Custom Stage Path
property to load data.
Procedure
-
Click Advanced settings of the
tSnowflakeOutputBulk component to open its
Advanced settings view.
-
Select the Use Custom Stage Path check box and enter
@~/demo within double quotes. As a result, the
Stage Folder you specified in the Basic
settings is disabled.
-
Select Default from the Put Command
Options drop-down list.
-
Set Put Command Error Retry to
3.
-
Clear the Stop on non-empty Storage Folder check
box.
-
Click Advanced settings of the
tSnowflakeBulkExec component to open its
Advanced settings view.
-
Select the Convert columns and table to uppercase check
box to convert the columns to uppercase.
-
Select Use Custom Stage Path and enter
@~/demo within double quotes. As a result, the
Stage Folder you specified in the Basic
settings is disabled.
-
Clear the Use Custom Storage Location check box.
-
Select Manual from the Copy Command
Options drop-down list and enter ON_ERROR='continue'
FILE_FORMAT=(type=csv field_delimiter=',' compression=gzip
field_optionally_enclosed_by='\"') within double quotes.
