MSCEWI4018
Object_Id replace with select statement
This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.
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
No additional user actions are required.
If you need more support, you can email us at [email protected]
Last updated