Question
COPY INTO <table> validation versus ON_ERROR: how do their purposes differ?
Answer
VALIDATION_MODE examines eligible files and returns detected issues without loading rows. ON_ERROR controls what a load does after conversion errors occur. Validate before a risky load; use ON_ERROR for the accepted runtime error-handling policy.