Output Code

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.

Source Code

Suppose this is the input source code you've migrated:

IN -> Teradata_01.sql
CREATE TABLE! TABLE_Invalid
(
  COL1 VARCHAR2(255),
  COL2 VARCHAR2
);

CREATE TABLE TABLE1
(
  COL1 INT,
  COL2 VARCHAR2!
);

CREATE OR REPLACE VIEW VIEW1
AS
    SELECT 
        UNKOWN_FUNCTION(1), 
        COL1, 
        COL2 
    FROM TABLE1
;

Output code

OUT -> Teradata_01.sql
-- ** SSC-EWI-0001 - UNRECOGNIZED TOKEN ON LINE '1' COLUMN '0' OF THE SOURCE CODE STARTING AT 'CREATE'. EXPECTED 'Create table Statement' GRAMMAR. LAST MATCHING TOKEN WAS 'TABLE' ON LINE '1' COLUMN '7'. FAILED TOKEN WAS '!' ON LINE '1' COLUMN '12'. **
--CREATE TABLE! TABLE_Invalid
--(
--  COL1 VARCHAR2(255),
--  COL2 VARCHAR2
--)
 ;

        CREATE OR REPLACE TABLE TABLE1
        (
          COL1 INT
--                  ,
-- ** SSC-EWI-0001 - UNRECOGNIZED TOKEN ON LINE '10' COLUMN '3' OF THE SOURCE CODE STARTING AT 'COL2'. EXPECTED 'Column Definition' GRAMMAR. LAST MATCHING TOKEN WAS 'VARCHAR2' ON LINE '10' COLUMN '8'. **
--  COL2 VARCHAR2!
)
        COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "teradata",  "convertedOn": "07/10/2025",  "domain": "no-domain-provided" }}'
;

        --** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "UNKOWN_FUNCTION" **
        CREATE OR REPLACE VIEW VIEW1
        COMMENT = '{ "origin": "sf_sc", "name": "snowconvert", "version": {  "major": 0,  "minor": 0,  "patch": "0" }, "attributes": {  "component": "teradata",  "convertedOn": "07/10/2025",  "domain": "no-domain-provided" }}'
        AS
        SELECT
          UNKOWN_FUNCTION(1) !!!RESOLVE EWI!!! /*** SSC-EWI-0073 - PENDING FUNCTIONAL EQUIVALENCE REVIEW FOR 'UNKOWN_FUNCTION' NODE ***/!!!,
          COL1,
          COL2
    FROM
          TABLE1
;

How to interpret the output code?

  • There is one parsing error in line number one. This is because of an invalid token CREATE TABLE!

  • There is another parsing error on line 10. This is because of an invalid tokenVARCHAR2!

  • There is an unknown function UNKNOWN_FUNCTION , which is translated as is, but warning SSC-EWI-0073 is added to indicate that this is something that has not been checked yet and therefore, the functional equivalence cannot be assured.

Last updated