MSCEWI5015

CREATE VIEW OF TYPE IS NOT SUPPORTED

Severity

High

Description

The use of Create View Of Type is not supported in Snowflake.

Example Code

Input Code:

CREATE VIEW testView
OF Rootview MODE DB2SQL(REF IS oidColumn USER GENERATED)
AS SELECT * FROM testTable;

Output Code:

-- ** MSC-ERROR - MSCEWI5015 - CREATE VIEW OF TYPE IS NOT SUPPORTED **
--CREATE VIEW testView
--OF Rootview MODE DB2SQL(REF IS oidColumn USER GENERATED)
--AS SELECT * FROM testTable

Recommendations

  • If this error happens is because there is no Snowflake equivalent for the node that is being converted.

  • If you need more support, you can email us at snowconvert-support@snowflake.com

Last updated