correct answer is B,C,D
Using a query as the source for the COPY statement for column reordering, column omission, and casts (i.e. transforming data during a load) is supported. For usage examples, see Transforming data during a load. Note that only simple SELECT statements are supported. Filtering using a WHERE clause is not supported.
Using a query as the source for the COPY statement for column reordering, column omission, and casts (i.e. transforming data during a load) is supported.
https://docs.snowflake.com/en/sql-reference/sql/create-pipe#usage-notes
Using a query as the source for the COPY statement for column reordering, column omission, and casts (i.e. transforming data during a load) is supported.
A: You can specify a WHERE clause to filter data before it is copied into Snowflake. This allows you to select specific rows based on certain conditions.
B: When you define the structure of the target table in Snowflake using CREATE PIPE, you can specify the order of columns. This means you can control the order in which incoming data columns are mapped to the target table.
C: Similar to reordering columns, you can specify only the columns from the incoming data that you want to copy into the target table. Columns that are not specified in the CREATE PIPE statement will be ignored during the data copy process.
B, C, D. You can't use where clauses in a copy into statement
upvoted 2 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
akellaanurag
3 weeks, 1 day agoAcaer
2 months, 1 week ago6c79d6f
2 months, 1 week agoimdashi
3 months, 3 weeks agoNachoPrendes
4 months agoMSIDDIQUI18
4 months, 2 weeks agoAtomic_Gecko
8 months, 3 weeks ago