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