SSC-FDM-TD0010

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

Important Notice: Migration of Documentation Website

Please be advised that our documentation website is currently undergoing a migration to a new platform. To ensure you have access to the most up-to-date information, we kindly request that you visit our new documentation website located at:

Official Snowflake Snowconvert Documentation

For any immediate assistance or if you encounter any issues, please contact our support team at [email protected].

Thank you for your understanding.

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.

An example of the contents of DBC.COLUMNSV table in Teradata
An example of the contents of INFORMATION_SCHEMA.COLUMNS table in SnowFlake

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.

Code Example

Input Code:

IN -> Teradata_01.sql
SELECT columnname FROM dbc.columnsV WHERE tablename = 'TableN';

Output Code:

OUT -> Teradata_01.sql
SELECT
COLUMN_NAME AS COLUMNNAME
FROM
--** SSC-FDM-TD0010 - USES OF TABLE DBC.COLUMNSV ARE CONVERTED TO INFORMATION_SCHEMA.COLUMNS, BUT SOME COLUMNS MIGHT NOT HAVE AND EXACT MATCH IN SNOWFLAKE **
INFORMATION_SCHEMA.COLUMNS
WHERE
UPPER(RTRIM(TABLE_NAME)) = UPPER(RTRIM('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 [email protected]

Last updated