This is a deprecated version of the SnowConvert documentation, please visit the official site .
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;