What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
What transformations are supported when loading data into a table using the COPY INTO [table] command? (Choose two.)
The COPY INTO [table] command supports several transformations when loading data into a table. One such transformation is column reordering, which allows data from the source to be loaded into a different column order in the target table. Another transformation is column omission, enabling the exclusion of specific columns from the loading process. These transformations facilitate flexible and efficient data loading scenarios.
The COPY command supports: Column reordering column omission casts using a SELECT statement https://docs.snowflake.com/en/user-guide/data-load-transform