SSC-FDM-TD0021

Built-in reference to {0} is not supported in Snowflake.

Description

This error appears when a query referencing DBC.DATABASES table is executed, and the selected column has no equivalence in Snowflake.

Example Code

Input:

IN -> Teradata_01.sql

CREATE VIEW SAMPLE_VIEW
AS
SELECT PROTECTIONTYPE FROM DBC.DATABASES;

Output:

OUT -> Teradata_01.sql

CREATE OR REPLACE VIEW SAMPLE_VIEW
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},{"attributes":{"component":"teradata"}}'
AS
SELECT
--** SSC-FDM-TD0021 - BUILT-IN REFERENCE TO PROTECTIONTYPE IS NOT SUPPORTED IN SNOWFLAKE **
'' AS PROTECTIONTYPE
FROM
INFORMATION_SCHEMA.DATABASES;

Recommendations

• If you need more support, you can email us at [e-mail]