SSC-EWI-TS0001

User defined function body not generated

Severity

Critical

Some parts of the output code are omitted for clarity reasons.

Description

This EWI appears when SnowConvert handles a critical exception that causes the function body not to be generated during its translation.

Example Code

SQL Server

IN -> SqlServer_01.sql

CREATE FUNCTION func1 ()
RETURNS VARCHAR
SELECT
   *
FROM
   TABLE1

Snowflake

OUT -> SqlServer_01.sql

CREATE OR REPLACE FUNCTION func1 ()
RETURNS VARCHAR
LANGUAGE SQL
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"transact"}}'
!!!RESOLVE EWI!!! /*** SSC-EWI-TS0001 - THE BODY WAS NOT GENERATED FOR FUNCTION 'func1' ***/!!!
AS
$$

$$;

Recommendations

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