Snowflake Data Cloud Connector > Part III: SQL ELT with Snowflake Data Cloud Connector > SQL ELT optimization for mapping tasks > Configuring target copy command options
  

Configuring target copy command options

You can specify the copy command options to load data from Amazon S3 to Snowflake.
Specify the options in the Additional Write Runtime Parameters field in the Snowflake Data Cloud advanced target properties of the Target transformation.
When you specify multiple copy command options, separate each option with an ampersand &.
Note: The copy option MATCH_BY_COLUMN_NAME is not applicable.
For more information about the supported copy command options, see the Snowflake documentation at the following website: https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html