MSCEWI3094

ROWID pseudocolumn is not supported in Snowflake

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