SQLFlow Data Reference¶

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

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

Describe how the Relationship is generated

type

type, could be: simple, function, expression, constant, case or subquery
coordinate
code

code expression

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:

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

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:

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 is to describe the parameters during the storage process

Process will be generated when data flow moves from one table to another