SSC-EWI-0110

Transformation Not Performed Due To Missing Dependencies

Severity

Low

Description

When there are missing dependencies, the EWI is added to indicate that a transformation cannot be executed. SnowConvert utilizes abstract syntax trees to create a semantic model of the input code, which is then used to generate new code that replicates the functionality of the original source. However, in this particular scenario, the transformation could not be completed because the semantic model lacks certain dependencies.

Example code

Input Code :

IN -> SqlServer_01.sql

ALTER TABLE MissingTable ADD
CONSTRAINT constraint1  DEFAULT (suser_name()) FOR col1;

Output Code:

OUT -> SqlServer_01.sql

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "MissingTable" **
!!!RESOLVE EWI!!! /*** SSC-EWI-0110 - TRANSFORMATION NOT PERFORMED DUE TO MISSING DEPENDENCIES ***/!!!

ALTER TABLE MissingTable
ADD
CONSTRAINT constraint1 DEFAULT (CURRENT_USER()) FOR col1;

Recommendations

• Add the missing dependencies to the input code.

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