MSCEWI5015

CREATE VIEW OF TYPE IS NOT SUPPORTED

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

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