MSCEWI2042

Table columns between tables (Teradata) DBC.COLUMNSV and INFORMATION_SCHEMA.COLUMNS (SnowFlake). But some columns might not have an exact match in Snowflake.

Severity

Low

Description

Uses of the table DBC.COLUMNSV in Teradata are converted to INFORMATION_SCHEMA.COLUMNS, but some columns might not have an exact match in SnowFlake. That means there are some columns in Teradata for which there is no equivalent in SnowFlake, and there are others that do have a matching column but the content is not exactly the same.

Notice, for example, that there is no equivalent column for "ColumnFormat" in SnowFlake and notice also that "DATA_TYPE" seems to be the match for the column "ColumnType" in Teradata, but their content greatly differ.

Example Code

Input Code:

SELECT columnname FROM dbc.columnsV WHERE tablename = 'TableN';

Output Code:

SELECT
/*** MSC-WARNING - MSCEWI2042 - USES OF TABLE DBC.COLUMNSV ARE CONVERTED TO INFORMATION_SCHEMA.COLUMNS, BUT SOME COLUMNS MIGHT NOT HAVE AND EXACT MATCH IN SNOWFLAKE ***/
COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE TABLE_NAME = 'TableN';

Recommendations

  • Review what columns were used in Teradata and check if the available content in SnowFlake matches your needs.

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