MSCEWI2030

The Protection Type reference is not supported in Snowflake.

Severity
Medium
Description
This error appears when a query to the DBC.DATABASES table is executed, and the selected column has no equivalence in Snowflake.  
Code Example
Input Code:
CREATE VIEW SAMPLE_VIEW
AS
SELECT PROTECTIONTYPE FROM DBC.DATABASES;
Output Code:
CREATE OR REPLACE VIEW PUBLIC.SAMPLE_VIEW
AS
SELECT
-- ** MSC-ERROR - MSCEWI2030 - THE PROTECTIONTYPE DBC REFERENCE NOT SUPPORTED IN SNOWFLAKE **
--PROTECTIONTYPE
FROM INFORMATION_SCHEMA.DATABASES;
Recommendations
No additional user actions are required.
For more support, you can email us at [email protected] or post a message to our forums. If you have a contract for support with Mobilize.Net, reach out to your sales engineer and they can direct your support needs.

MSCEWI2029

MSCEWI2031

Last modified 1yr ago