What transformations are supported in the below SQL statement? (Select THREE). CREATE PIPE ... AS COPY ... FROM (...)

Question

Options

• AData can be filtered by an optional where clause.
• BColumns can be reordered.
• CColumns can be omitted.
• DType casts are supported.
• EIncoming data can be joined with other tables.
• FThe ON ERROR - ABORT statement command can be used.

• A
  90% (19)
• E
  5% (1)
• F
  5% (1)

Explanation

When using a SELECT subquery within a COPY INTO statement (as used in CREATE PIPE), Snowflake supports a specific subset of SQL transformations. A: A WHERE clause can be used to filter rows during ingestion, allowing selective loading of records. B: Columns can be reordered by listing them in a different sequence in the SELECT clause, useful when the source file layout differs from the target table. C: Columns can be omitted from the SELECT to skip fields not needed in the target table. Option D (type casts) is not supported within the transformation query of a Snowpipe COPY statement - type coercion must be handled in a separate transformation step. Option E (joining with other tables) is not supported inside COPY transformations. Option F (ON ERROR = ABORT) is a COPY option, not a transformation supported inside the SELECT subquery.

No community discussion yet for this question.