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.
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.
Snowflake file load
Copy options set with OPT_SF_FILE_COPY_OPTIONS:
File load executed in Snowflake:
COPY INTO ...