MSCEWI3094

ROWID pseudocolumn is not supported in Snowflake

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

Severity

Medium

Description

When ROWID is used as a pseudocolumn in a query it is transformed to null in order to avoid runtime errors and the EWI is added. There is still no transformation to emulate the functionality.

Example Code

Input Code:

SELECT ROWID FROM T1;

Output Code:

SELECT
/*** MSC-ERROR - MSCEWI3094 - ROWID PSEUDOCOLUMN IS NOT SUPPORTED IN SNOWFLAKE, IT WAS CONVERTED TO NULL TO AVOID RUNTIME ERRORS ***/
null
FROM PUBLIC.T1;

Recommendations

• No end-user action is required.

• If you need more support, you can email us at [email protected]