Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?

Which of the below transformations are supported by Snowflake while loading a table using the COPY statement?
A . Column reordering
B. Column renaming
C. Column omission
D. Casts
E. Truncating text strings that exceed the target column length

View Answer

Answer: A, C, D, E

Explanation

Simple Transformations During a Load

Snowflake supports transforming data while loading it into a table using the COPY command. Options include: