SSC-FDM-OR0030

ROWID pseudocolumn is not supported in Snowflake

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 Oracle:

IN -> Oracle_01.sql

SELECT ROWID FROM T1;

Output Code:

OUT -> Oracle_01.sql

SELECT
--** SSC-FDM-OR0030 - ROWID PSEUDOCOLUMN IS NOT SUPPORTED IN SNOWFLAKE, IT WAS CONVERTED TO NULL TO AVOID RUNTIME ERRORS **
'' AS ROWID
FROM
T1;

Recommendations

• No end-user action is required.

• If you need more support, you can email us at [e-mail]