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