copy_options

Target database: Snowflake

Resolved as the Snowflake copy options in file load execution.

See also:

• Variables

• OVERRIDE_FILE_LOAD

• OPT_SF_FILE_COPY_OPTIONS

• Copy Options (Snowflake documentation)

Usage

<copy_options>

Notes

Supported in file loads in Snowflake.

Examples

Using variable in an OVERRIDE_FILE_LOAD step

Copy options set with OPT_SF_FILE_COPY_OPTIONS:

ON_ERROR=ABORT_STATEMENT PURGE=TRUE

File load customized with OVERRIDE_FILE_LOAD:

COPY INTO ...
FROM ...
<copy_options>

File load executed in Snowflake:

COPY INTO ...
FROM ...
ON_ERROR=ABORT_STATEMENT PURGE=TRUE