Links

MSCEWI4018

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.

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.
  • 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.