MSCEWI1050

Element with missing dependencies

This is a deprecated version of the SnowConvert documentation, please visit the official site HERE.

Severity

Low

Description

There is a missing dependency for an object, Snow Convert could not resolve some data types. Also there exists a possibility to have a deployment error if the dependency was not in the source code.

Example Code

Input Code:

CREATE VIEW VIEW01 AS SELECT * FROM TABLE1;

Output Code:

/*** MSC-WARNING - MSCEWI1050 - MISSING DEPENDENT OBJECT "TABLE1" ***/
CREATE VIEW PUBLIC.VIEW01
AS
SELECT * FROM PUBLIC.TABLE1;

Note that the TABLE1 definition is missing.

Recommendations

• Make sure all the dependencies of the objects are in the source code.

• If not, find the references to the object in the code and check if the operations are well managed.

• If you need more support, you can email us at [email protected]