MSCEWI4018

Object_Id replace with select statement

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

This EWI is deprecated. If you get it from a migration, we recommend updating SnowConvert and re-run the migration.

Severity

Low

Description

This EWI is added when SnowConvert replaces an ObjectID function with a Select Statement in order to preserve functional equivalence.

Code Example

Input Code:

IF OBJECT_ID(@ObjectName) IS NULL
    SELECT * FROM TABLE1;

Output Code:

--** MSC-WARNING - MSCEWI4018 - OBJECT_ID FUNCTION IS NOT SUPPORTED IN SNOWFLAKE. A SELECT IS INSERTED TO EMULATE BEHAVIOR**
(SELECT OBJECT_SCHEMA || '.' || OBJECT_NAME AS object_id FROM INFORMATION_SCHEMA.OBJECT_PRIVILEGES WHERE object_id = 'PUBLIC.TABLE1')

Recommendations

Last updated