Snowflake DBA

Data Loading & Unloading Operations

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.

This is 9 of 21 free samples for Snowflake DBA.

More Snowflake DBA topic samples