ROWID
Translation spec for ROWID pseudocolumn
Description
For each row in the database, the
ROWID
pseudocolumn returns the address of the row. (Oracle SQL Language Reference Rowid pseudocolumn)
Snowflake does not have an equivalent for ROWID. The pseudocolumn is transformed to NULL in order to avoid runtime errors.
ROWID
Sample Source Patterns
Oracle
CREATE TABLE sample_table
(
sample_column varchar(10)
);
INSERT INTO sample_table(sample_column) VALUES ('text 1');
INSERT INTO sample_table(sample_column) VALUES ('text 2');
SELECT ROWID FROM sample_table;
SELECT MAX(ROWID) FROM sample_table;
Snowflake
CREATE OR REPLACE TABLE PUBLIC.sample_table (
sample_column varchar(10));
INSERT INTO PUBLIC.sample_table(sample_column) VALUES ('text 1');
INSERT INTO PUBLIC.sample_table(sample_column) VALUES ('text 2');
SELECT
/*** MSC-ERROR - MSCEWI3094 - ROWID PSEUDOCOLUMN IS NOT SUPPORTED IN SNOWFLAKE, IT WAS CONVERTED TO NULL TO AVOID RUNTIME ERRORS ***/
null
FROM PUBLIC.sample_table;
SELECT MAX(/*** MSC-ERROR - MSCEWI3094 - ROWID PSEUDOCOLUMN IS NOT SUPPORTED IN SNOWFLAKE, IT WAS CONVERTED TO NULL TO AVOID RUNTIME ERRORS ***/
null) FROM PUBLIC.sample_table;
Known Issues
No issues were found.
Related EWIs
MSCEWI3094: ROWID pseudocolumn is not supported in Snowflake.
Last updated
Was this helpful?