What is the default behavior of ON ERROR when loading staged data into the target table using COPY INTO?

• A. Copy Into Command stops loading in case of any error file
• B. Copy Into Command continues on error
• C. Copy Into Command stops entire operation on first error
• D. Copy Into Command logs error and continues

Answer: (A)

When you load data with COPY INTO from a stage to a table, ON_ERROR controls what happens if something goes wrong during the load. By default, the operation is aborted as soon as an error is encountered, so no data from that COPY INTO is loaded and an error is returned. This behavior protects data integrity by avoiding partial or inconsistent loads. If you want to keep loading despite errors, you would explicitly set ON_ERROR to continue or to skip the problematic file, but that changes the default behavior.