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]
Last updated