Which statement best describes the handling of ON_ERROR settings for bulk loading and Snowpipe?

• A. They are identical defaults
• B. They can be configured only for bulk loading
• C. They have different default options
• D. Snowpipe cannot be configured

Answer: (C)

ON_ERROR handling is tied to the ingestion path, and bulk loading and Snowpipe use different defaults and configuration points. Bulk loading via COPY INTO has its own ON_ERROR behavior defined per load operation, with a default that differs from Snowpipe and options to tailor what happens when a row or file causes an error. Snowpipe, as a continuous ingestion service, uses a separate, pipe-level ON_ERROR setting with its own default designed to keep ingestion moving, while allowing adjustments if needed. Because these two paths manage errors differently and don’t share the same default, they have different default options.