SSC-EWI-TD0092

Translation for Teradata Built-In Table/View is not currently supported

Severity

Low

Description

This EWI is added when SnowConvert finds a Teradata system table that is currently not translated.

Example Code

Input Code:

IN -> Teradata_01.sql

SELECT
  CRLF || 
  TRIM(em.ErrorText) INTO :MsgText
FROM
  DBC.ErrorMsgs em
WHERE
  em.ErrorCode = SUBSTR(:SqlStateCode, 2, 4)

Output Code

OUT -> Teradata_01.sql

SELECT
  CRLF ||
  TRIM(em.ErrorText) INTO :MsgText
FROM
  !!!RESOLVE EWI!!! /*** SSC-EWI-TD0092 - TRANSLATION FOR TERADATA BUILT-IN TABLE/VIEW DBC.ErrorMsgs IS NOT CURRENTLY SUPPORTED. ***/!!!
  DBC.ErrorMsgs em
WHERE
  UPPER(RTRIM(
  em.ErrorCode)) = UPPER(RTRIM(SUBSTR(:SqlStateCode, 2, 4)));

Recommendations

• Search in Snowflake's internal tables, such as Information_Schema or SNOWFLAKE.ACCOUNT_USAGE for equivalents

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