MSCEWI3025

Synonyms are not supported in Snowflake but references to this synonym were changed by the original object name.

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