OPT_SF_FILE_COPY_OPTIONS

Target database: Snowflake

OPT_SF_FILE_COPY_OPTIONS is a Snowflake specific load option that overrides copy options in the file load COPY INTO command.

See also:

• Loading source data (guide)

• Load options

• OVERRIDE_FILE_LOAD

• COPY INTO (Snowflake documentation)

Usage

OPT_SF_FILE_COPY_OPTIONS: sql_code

Notes

OPT_SF_FILE_COPY_OPTIONS can be used with file loads when the target database is Snowflake.

OPT_SF_FILE_COPY_OPTIONS is also supported in OVERRIDE_FILE_LOAD load steps where it will be resolved in place of the <copy_options> variable.

Examples

Snowflake file load

Copy options set with OPT_SF_FILE_COPY_OPTIONS:

OPT_SF_FILE_COPY_OPTIONS: 
ON_ERROR=ABORT_STATEMENT PURGE=TRUE

File load executed in Snowflake:

COPY INTO ...
FROM ...
FILE_FORMAT=(...)
ON_ERROR=ABORT_STATEMENT PURGE=TRUE;