Which transformation is supported by a COPY INTO command?

B. Filter using a limit keyword

D. Order using an ORDER BY clause

Snowflake

COF-C02 · Question #305

Which transformation is supported by a COPY INTO <table> command?

The correct answer is C. Cast using a SELECT statement. The COPY INTO <table> command supports a limited set of transformations via a SELECT statement in the COPY query. Supported transformations include: column reordering, column omission, and casting (type conversion) using a SELECT statement. It does NOT support filtering with…

Data Loading and Unloading

Question

Which transformation is supported by a COPY INTO <table> command?

Options

AFilter using a where clause
BFilter using a limit keyword
CCast using a SELECT statement
DOrder using an ORDER BY clause

How the community answered

(55 responses)

A
2% (1)
B
2% (1)
C
93% (51)
D
4% (2)

Explanation

The COPY INTO <table> command supports a limited set of transformations via a SELECT statement in the COPY query. Supported transformations include: column reordering, column omission, and casting (type conversion) using a SELECT statement. It does NOT support filtering with WHERE clauses, limiting rows with LIMIT, or sorting with ORDER BY. If you need filtering or ordering, you should use an external stage query or a separate transformation step after loading.

Topics

#COPY INTO#Data Loading#Inline Transformations#Data Casting

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice