What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

The correct answer is A. Data can be filtered by an optional where clause D. Columns can be omitted. Within a CREATE PIPE ... AS COPY INTO ... FROM (SELECT ...) statement, Snowflake supports a limited set of transformations via the inline SELECT. Columns can be omitted by simply not including them in the SELECT list - this is one of the primary use cases for inline…

Data Transformations

Question

Options

AData can be filtered by an optional where clause
BIncoming data can be joined with other tables
CColumns can be reordered
DColumns can be omitted
ERow level access can be defined

How the community answered

(28 responses)

A
89% (25)
B
4% (1)
C
7% (2)

Explanation

Within a CREATE PIPE ... AS COPY INTO ... FROM (SELECT ...) statement, Snowflake supports a limited set of transformations via the inline SELECT. Columns can be omitted by simply not including them in the SELECT list - this is one of the primary use cases for inline transformation. A WHERE clause can be used to filter rows, allowing conditional loading based on column values in the staged files. Column reordering (option C) is not supported in this context as it can cause schema mismatches. Joining with other tables (option B) is not supported because the COPY INTO pipeline is designed for staged file ingestion only. Row-level access policies (option E) are a security feature applied at query time, not during ingestion.

Topics

#CREATE PIPE#COPY INTO#Data Loading#In-line Transformations

Community Discussion

No community discussion yet for this question.

Full COF-C02 Practice