Links

MSCEWI1042

Non-relevant syntax

Severity

Low

Description

This warning is added to a transformation when some elements had to be removed, but it does not affect the result of the transformed query due to it not having an impact on Snowflake DB environment.

Example Code

Input Code:

INSERT INTO table1 (column1)
SELECT value1 FROM table2
LOGGING ALL ERRORS WITH NO LIMIT;

Output Code:

INSERT INTO PUBLIC.table1 (column1)
SELECT
value1 FROM
PUBLIC.table2
--** MSC-WARNING - MSCEWI1042 - Commented LOGGING ERRORS - THIS IS NON-RELEVANT **
--LOGGING ALL ERRORS WITH NO LIMIT
;

Recommendation