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

The correct answer is A. CONTINUE B. SKIP_FILE C. ABORT_STATEMENT. The ON_ERROR clause in Snowflake's COPY INTO command accepts the following valid options: CONTINUE (skip erroneous rows and continue loading), SKIP_FILE (skip the entire file that contains errors), SKIP_FILE_<num> or SKIP_FILE_<num>% (skip a file if the number/percentage of error

Data Engineering

Question

Options

ACONTINUE
BSKIP_FILE
CABORT_STATEMENT
DFAIL

How the community answered

(24 responses)

A
92% (22)
D
8% (2)

Explanation

The ON_ERROR clause in Snowflake's COPY INTO command accepts the following valid options: CONTINUE (skip erroneous rows and continue loading), SKIP_FILE (skip the entire file that contains errors), SKIP_FILE_<num> or SKIP_FILE_<num>% (skip a file if the number/percentage of errors exceeds a threshold), and ABORT_STATEMENT (default - abort the COPY operation if any error is encountered). 'FAIL' (option D) is NOT a valid ON_ERROR value in Snowflake. The three correct answers - CONTINUE, SKIP_FILE, and ABORT_STATEMENT - are the core options available for controlling error handling behavior during data loading.

Topics

#COPY INTO#Data Loading#Error Handling#Stages

Community Discussion

No community discussion yet for this question.

Full ARA-C01 Practice