MSCEWI3025
Synonyms are not supported in Snowflake but references to this synonym were changed by the original object name.
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
Severity
Low
Description
Synonyms are not supported in Snowflake. The synonyms are replaced by the original name.
Example Code
Input Code:
CREATE TABLE TABLE1
(
COLUMN1 NUMBER
);
CREATE OR REPLACE SYNONYM B.TABLE1_SYNONYM FOR TABLE1;
SELECT * FROM B.TABLE1_SYNONYM WHERE B.TABLE1_SYNONYM.COLUMN1 = 20;
Output Code:
CREATE OR REPLACE TABLE PUBLIC.TABLE1 (
COLUMN1 NUMBER (38,19) NOT NULL);
-- ** MSC-WARNING - MSCEWI3025 - SYNONYMS NOT SUPPORTED IN SNOWFLAKE BUT REFERENCES TO THIS SYNONYM WERE CHANGED BY THE ORIGINAL OBJECT NAME. **
--CREATE OR REPLACE SYNONYM B.TABLE1_SYNONYM FOR TABLE1
;
SELECT * FROM TABLE1 WHERE TABLE1.COLUMN1 = 20;
Recommendations
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated