Lineage Report

This page describes the fields present in the Lineage.csv report

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

Description

This report holds the information of relationships between database objects when used together in SQL Commands. This is done only for SQL Commands in scripts.

Fields

• Relationship: Indicates the type of script where the relationship is present, possible values are BTEQ, FastLoad, MultiLoad, TPump and TPT.

• Script: Name of the file where the relationship was found.

• Target_Object_DB: Database the target object belongs to.

• Target_Object_Name: The name of the object that is being modified by the action.

• Source_Object_DB: Database the source object belongs to.

• Source_Object_Name: The name of the object whose data is being extracted to be used in the action.

• Action: The SQL Command the relationship information is registered, possible values are CREATE TABLE AS SELECT, CREATE VIEW, DELETE, INSERT, MERGE or UPDATE.

Example

Migrating a file named Example.bteq with the following contents:

.LOGON ${SID}/${UID}, ${PWD};

CREATE TABLE ${DBC}.exampleTable AS (
    SELECT 
        id,
        phone,
        emp_name,
        CASE WHEN work_status = 'V' THEN 'On vacations' ELSE 'Available' END emp_availability
    FROM
        ${employees_db}.vacations_info
);

INSERT INTO ${DBC}.exampleTable SELECT * from ${HR_DB}.managers_vacations;

DELETE FROM ${HR_DB}.managers_vacations;

.LOGOFF
.EXIT

It will generate the following entries in the Lineage Report:

Relationship	Script	Target_Object_DB	Target_Object_Name	Source_Object_DB	Source_Object_Name	Action
BTEQ	Example.bteq	${DBC}	exampleTable	${employees_db}	vacations_info	Create Table As Select
BTEQ	Example.bteq	${DBC}	exampleTable	${HR_DB}	managers_vacations	Insert
BTEQ	Example.bteq	${HR_DB}	managers_vacations			Delete