SSC-FDM-OR0030

ROWID pseudocolumn is not supported in Snowflake

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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 [email protected]

Last updated