MSCEWI3119

Supplemental logging clause commented out

Severity
Low
Description
Oracle supplemental log is not supported in Snowflake. 
By removing the statement, the functional equivalence of the table is preserved, that is why we just comment out the clause and add this LOW severity warning.
Example Code
Input Code:
CREATE TABLE table1
(
	col1 DATE,
	SUPPLEMENTAL LOG DATA (ALL) COLUMNS
);
Output Code:
CREATE OR REPLACE TABLE PUBLIC.table1 (
col1 DATE,
-- ** MSC-WARNING - MSCEWI3119 - SUPPLEMENTAL LOGGING CLAUSE COMMENTED OUT BECAUSE IS NOT NEEDED IN SNOWFLAKE. **
--SUPPLEMENTAL LOG DATA (ALL) COLUMNS
);
Recommendations
You can browse some historical activity information in Account Usage, Query history and Snowflake time travel and fail-safe features. 
If you need more support, you can email us at [email protected]​

MSCEWI3118

MSCEWI3120

Last modified 3mo ago