When loading data into Snowflake, the COPY command supports which of the following?
When loading data into Snowflake, the COPY command supports which of the following?
When loading data into Snowflake using the COPY command, it indeed supports column reordering. This functionality allows users to load data into tables where the desired column order in the file does not match the order in the table, by specifying the columns in a list. This helps in ensuring that the data is correctly mapped to the table schema despite differences in column ordering.
https://docs.snowflake.com/en/user-guide/data-load-transform.html#reorder-csv-columns-during-a-load
Verified