Snowpipe ON_ERROR SKIP_FILE results in what?

• A. The entire pipeline stops
• B. The problematic file is skipped and processing continues
• C. The pipeline retries the file
• D. It logs and halts

Answer: (B)

ON_ERROR = SKIP_FILE means Snowpipe will skip the file that caused the error and continue processing subsequent files. This prevents a single bad file from blocking the entire load, and the skipped file is logged so you can review it later. There’s no automatic retry for that file under this setting, and the rest of the data continues to load as normal. This is useful when you want high throughput and don’t want one malformed file to halt everything.