Object_Id replace with select statement
This EWI is deprecated. If you get it from a migration, we recommend updating SnowConvert and re-run the migration.
This EWI is added when SnowConvert replaces an ObjectID function with a Select Statement in order to preserve functional equivalence.
IF OBJECT_ID(@ObjectName) IS NULL
SELECT * FROM TABLE1;
--** 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')
- No additional user actions are required.
- For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.