SSC-FDM-0007

Element with missing dependencies

Some parts of the output code are omitted for clarity reasons

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:

IN -> Teradata_01.sql

CREATE VIEW VIEW01 AS SELECT * FROM TABLE1;

Output Code:

OUT -> Teradata_01.sql

--** SSC-FDM-0007 - MISSING DEPENDENT OBJECT "TABLE1" **
CREATE OR REPLACE VIEW VIEW01
COMMENT = '{"origin":"sf_sc","name":"snowconvert","version":{"major":1, "minor":0},"attributes":{"component":"teradata"}}'
AS
--** SSC-FDM-0001 - VIEWS SELECTING ALL COLUMNS FROM A SINGLE TABLE ARE NOT REQUIRED IN SNOWFLAKE AND MAY IMPACT PERFORMANCE. **
SELECT
* FROM
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 [e-mail]