Data Lineage Elements

Target Fields Data
id
id of the target column 
name
name of the target column. the name would be the caller if the Relationship type is call 
column
column name
function
fucntion name if the relationship is from a function
target_id
target id if the target is not on column level
target_name
target name if the target is not on column level
parent_id
parent id of the target's parent node
parent_name
parent name of the target's parent node
parent_alias
parent alias of the target's parent node
coordinate
source
will be filtered out on UI if the source is from system
type
type of the storage process if the Relationship type is call. could be: procedure, function, trigger, macro
Source Fields Data
id
source column Id
name
caller name if the Relationship type is call
column
source column name
source_id
source id when the source is not on column level
source_name
source name when the source is not on column level
column_type
column type
parent_id
source parent node id 
parent_name
source parent node name
parent_alias
source parent node alias
coordinate
clauseType
source clause type
source
will be filtered out on UI if the source is from system
type
type of the storage process if the Relationship type is call. could be: procedure, function, trigger, macro
subnode in the SourceColumn 
transforms
Belongs to the Transform Structure
Transform Fields Data
Describe how the Relationship is generated
type
type, could be: simple, function, expression, constant, case or subquery
coordinate
code
code expression
Table Structure
id
table id
server
db server to which the table belongs
database
database to which the table belongs
schema
table schema
name
table name, database.schema.table for example. if there's no database the name would be schema.table. If there's no schema the name will be database.table
alias
alias name
uri
mapped url when table type is file, path, stage or stream
type
table type
subType
subtype of the type
processIds
linked process Ids
fileType
mapped file type if the table type is stage
fileFormat
mapped file format if table type is ``` _file, path, stage_ or _stream`_
location
location url if the table type is stage or datasource
isTarget
if display in UI
coordinate
element coordinate
parent
storage process of the table
more
if collaspe in the UI
Subnode in Table structure:
column
Belongs to the Column Structure
Column Structure
id
column id
name
column name
coordinate
column coordinate
source
column source. will not be dispalyed If source is system
qualifiedTable
Field which is used to distinguish the column when there are columns under the same name such as: table1.a, table2.a
OraclePackage Structure
id
package id
server
db server to which the package belongs
database
database to which the package belongs
schema
schema to which the package belongs
name
package name: database.schema.package The name would be : schema.package If there's no database . The name would be database.package if there 's no schema.
type
package type
coordinate
package coordinate
Subnode in OraclePackage structure:
procedure
Belongs to the Procedure Structure
Procedure Structure
id
procedure id
server
db server to which the procedure belongs
database
database to which the procedure belongs
schema
schema to which the procedure belongs
name
procedure name: database.schema.procedure The name would be : schema.procedure If there's no database . The name would be database.procedure if there 's no schema
if the procedure belongs to package, full name will also contain package segment
type
procedure type, could be procedure, function, trigger
coordinate
procedure coordinate
Subnode in procedure structure:
argument
Belongs to the Argument Structure
Argument Structure
Argument is to describe the parameters during the storage process
id
argument id
name
argument name
coordinate
argument coordinate
datatype
argument data type
inout
in or out type
Process Structure
Process will be generated when data flow moves from one table to another
id
process id
server
db server to which the process belongs
database
database to which the process belongs
schema
schema to which the process belongs
name
process name, different process can have the same name
procedureName
procedure to which the process belongs
procedureId
procedure id to which the process belongs
queryHashId
statement hashcode to which the process belongs
type
process type
coordinate
process coordinate
Last modified 5mo ago