MSCEWI3113

The error logging clause in DML statements is not supported by Snowflake

Severity
Medium
Description
This error is used to advise that the error_logging clause in Oracle's DML statements is not supported by Snowflake's DML statements. 
Example Code
Input Code
MERGE INTO people_target pt 
USING people_source ps ON (pt.person_id = ps.person_id) 
WHEN MATCHED THEN UPDATE 
  SET pt.first_name = ps.first_name, 
      pt.last_name = ps.last_name, 
      pt.title = ps.title
LOG ERRORS;
Output Code
/*** MSC-ERROR - MSCEWI3113 - ERROR LOGGING CLAUSE IN DML STATEMENTS IS NOT SUPPORTED BY SNOWFLAKE ***/
MERGE INTO PUBLIC.people_target pt USING PUBLIC.people_source ps ON (pt.person_id = ps.person_id)
WHEN MATCHED THEN UPDATE
SET pt.first_name = ps.first_name,
    pt.last_name = ps.last_name,
    pt.title = ps.title;
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]​

MSCEWI3112

MSCEWI3114

Last modified 3mo ago