What is the default ON_ERROR option for Snowpipe?

• A. ABORT_STATEMENT
• B. CONTINUE
• C. SKIP_FILE
• D. ABORT_FILE

Answer: (C)

Snowpipe is designed for continuous data ingestion, so its error-handling behavior is tuned to keep the stream flowing even when some data has issues. The default ON_ERROR setting makes Snowpipe skip any file that can’t be loaded due to errors, and then it continues processing subsequent files. This means a single problematic file won’t block all future ingestions, which is essential for a smooth, automated pipeline.

If a file has a fatal problem, other options would either halt the entire operation (abort the statement) or affect only the problematic file or its rows (abort the file, or continue with processing while logging errors). The skip behavior focuses on maintaining throughput and resilience in the ingestion process.