Data Lineage Elements
- idid of the target column
- namename of the target column. the name would be the caller if the Relationship type is
call
- columncolumn name
- functionfucntion name if the relationship is from a function
- target_idtarget id if the target is not on column level
- target_nametarget name if the target is not on column level
- parent_idparent id of the target's parent node
- parent_nameparent name of the target's parent node
- parent_aliasparent alias of the target's parent node
- coordinate
- sourcewill be filtered out on UI if the source is from system
- typetype of the storage process if the Relationship type is
call
. could be:procedure
,function
,trigger
,macro
- idsource column Id
- namecaller name if the Relationship type is
call
- column
- source column name
- source_idsource id when the source is not on column level
- source_namesource name when the source is not on column level
- column_typecolumn type
- parent_idsource parent node id
- parent_namesource parent node name
- parent_aliassource parent node alias
- coordinate
- clauseTypesource clause type
- sourcewill be filtered out on UI if the source is from system
- typetype of the storage process if the Relationship type is
call
. could be:procedure
,function
,trigger
,macro
subnode in the SourceColumn
- transformsBelongs to the Transform Structure
Describe how the Relationship is generated
- typetype, could be:
simple
,function
,expression
,constant
,case
orsubquery
- coordinate
- codecode expression
- idtable id
- serverdb server to which the table belongs
- databasedatabase to which the table belongs
- schema
- table schema
- nametable name,
database.schema.table
for example. if there's no database the name would beschema.table
. If there's no schema the name will bedatabase.table
- aliasalias name
- urimapped url when table type is
file, path, stage
orstream
- typetable type
- subTypesubtype of the type
- processIdslinked process Ids
- fileTypemapped file type if the table type is stage
- fileFormatmapped file format if table type is ```
_
file, path, stage_ or _
stream`_ - locationlocation url if the table type is
stage
ordatasource
- isTargetif display in UI
- coordinateelement coordinate
- parentstorage process of the table
- moreif collaspe in the UI
Subnode in Table structure:
- columnBelongs to the Column Structure
- id
- column id
- name
- column name
- coordinate
- column coordinate
- sourcecolumn 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
- idpackage id
- serverdb server to which the package belongs
- databasedatabase to which the package belongs
- schemaschema to which the package belongs
- namepackage name:
database.schema.package
The name would be :schema.package
If there's no database . The name would bedatabase.package
if there 's no schema. - typepackage type
- coordinatepackage coordinate
Subnode in OraclePackage structure:
- procedureBelongs to the Procedure Structure
- idprocedure id
- serverdb server to which the procedure belongs
- databasedatabase to which the procedure belongs
- schemaschema to which the procedure belongs
- nameprocedure name:
database.schema.procedure
The name would be :schema.procedure
If there's no database . The name would bedatabase.procedure
if there 's no schemaif the procedure belongs to package, full name will also contain package segment - typeprocedure type, could be
procedure
,function
,trigger
- coordinateprocedure coordinate
Subnode in procedure structure:
- argumentBelongs to the Argument Structure
Argument is to describe the parameters during the storage process
- idargument id
- nameargument name
- coordinateargument coordinate
- datatypeargument data type
- inoutin or out type
Process will be generated when data flow moves from one table to another
- id
- process id
- serverdb server to which the process belongs
- databasedatabase to which the process belongs
- schemaschema to which the process belongs
- nameprocess name, different process can have the same name
- procedureNameprocedure to which the process belongs
- procedureIdprocedure id to which the process belongs
- queryHashIdstatement hashcode to which the process belongs
- typeprocess type
- coordinateprocess coordinate
Last modified 5mo ago