MSCEWI3119

Supplemental logging clause commented out

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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]