When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?

When loading data from stage using COPY INTO, what options can you specify for the ON_ERROR clause?
A . CONTINUE
B. SKIP_FILE
C. ABORT_STATEMENT
D. FAIL

Answer: A,B,C

Explanation:

Copy Options (copyOptions)

You can specify one or more of the following copy options (separated by blank spaces, commas, or new lines):

ON_ERROR = CONTINUE | SKIP_FILE | SKIP_FILE_num | SKIP_FILE_num% | ABORT_STATEMENT

String (constant) that specifies the action to perform when an error is encountered while loading data from a file:

https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html#copy-options-copyoptions

Latest ARA-C01 Dumps Valid Version with 156 Q&As

Latest And Valid Q&A | Instant Download | Once Fail, Full Refund

Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments