Breadcrumbs

copy_options

Target database: Snowflake

Resolved as the Snowflake copy options in file load execution.


See also:


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:

SQL
ON_ERROR=ABORT_STATEMENT PURGE=TRUE

File load customized with OVERRIDE_FILE_LOAD:

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

File load executed in Snowflake:

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