Gudu SQLFlow Product Docs
  • 1. Introduction
    • What is Gudu SQLFlow?
      • What SQLFlow can do
      • Architecture Overview
    • Getting Started
      • Sign up a new account
        • Team Management
        • Delete My Account
        • Activate by entering a coupon
      • How to use SQLFlow
      • Different modes in Gudu SQLFlow
        • Query mode
        • Job mode
      • Basic Usage
      • Convert SQL to E-R Diagram
      • Colors in SQLFlow Diagram
      • Show call relationship
    • Installation
      • Version and Users
        • Cloud and On-Premise version
        • SQLFlow before Version 6
          • For older version SQLFlow under Linux
          • For older version SQLFlow under MacOS
          • For older version SQLFlow under Windows
      • Linux
      • MacOS
      • Windows
      • Docker
      • Clickhouse Installation
        • Clickhouse For CentOs
        • Clickhouse For Ubuntu/Debian/RHEL
      • Troubleshooting
      • Upgrade
      • Third Party Components
      • Renew License File
    • UI
      • SQLText Editor
      • Schema Explorer
      • Diagram Panel
      • Settings
      • Job Management
        • Job Sources
    • Dlineage Tool
      • Overview
      • Usage
        • Analyze data linege from SQL files
        • Analyze data linege from a database
        • Resolve the ambiguous columns in SQL query
        • Map the DataFlowAnalyzer and the settings on SQLFlow UI
        • Settings
      • Dataflow.xml structure
      • FAQ
  • 2. CONCEPTS
    • Data Lineage Basics
      • Dataflow
        • Relations generated by SQLFlow
      • Direct Dataflow
      • Indirect Dataflow
      • Aggregate function and Dataflow
      • Dataflow chain
    • Data Lineage Format Reference
  • 3. API Docs
    • Prerequisites
    • Using the Rest API
    • SQLFlow Rest API reference
      • User Interface
      • Generation Interface
        • /sqlflow
        • /sqlflow/selectedgraph/table_level_lineage
        • /sqlflow/selectedgraph/image
        • /sqlflow/graph
        • /sqlflow/graph/table_level_lineage
        • /sqlflow/graph/image
        • /sqlflow/downstreamGraph
        • /sqlflow/upstreamGraph
        • /sqlflow/erdiagramSelectGraph
        • /sqlflow/leftMostSourceTableGraph
      • Job Interface
        • /submitUserJob
        • /displayUserJobSummary
        • /displayUserJobsSummary
        • /exportLineageAsJson
        • /exportFullLineageAsJson
        • /exportLineageAsGraphml
        • /submitPersistJob
        • /displayUserLatestJobTableLevelLineage
      • Export Image
      • Export CSV
        • /sqlflow/exportFullLineageAsCsv
        • /job/exportFullLineageAsCsv
    • Swagger UI
    • Export the data lineage result
    • Python
      • Basic Usage
      • Advanced Usage
    • SQL Parser API
      • checkSyntax
  • 4. SQLFlow Widget
    • Widget Get started
    • Usages
    • Widget API Reference
  • 5. Databases
    • Database Objects
      • Azure
      • DB2
  • 6. SQLFlow-ingester
    • Introduction
      • SQLFlow-Exporter
      • SQLFlow-Extractor
      • SQLFlow-Submitter
    • Get Started
      • SQL Server
    • SQLFlow-Ingester Java API Usage
    • Understand the format of exported data
      • Oracle
      • Microsoft SQL Server
      • MySQL
      • PostgreSQL
    • List of Supported dbVendors
    • Git Repo
    • Third Party Components
  • 7. Reference
    • Lineage Model
      • Json Format Lineage Model
      • XML Format Lineage Model
      • Data Lineage Elements
    • Database Model
  • 8. other
    • FAQ
      • Handling Internal Database
      • Delete Your Account
      • Table Form Data Without Intermediates
      • Not all schema exported from Oracle
      • Lineage Customization
    • Roadmap
    • SQL Samples
      • Exchange table partition
      • Generate relationship for renamed table
      • Snowflake table function lineage detection
    • Change Logs
    • SQLFlow with Oracle XML functions
    • Major Organizations Utilizing SQLFlow
Powered by GitBook
On this page
  • Schema Explorer Basic
  • Visualization Control
  • visualize
  • visualize with cloumns
  • to left most
  • to left most with columns
  • copy
  • to upstream/to downstream
  • to upstream/to downstream step by step
  • View DDL(Data Definition Language)
  • Different Schema Structures
  • database.schema.table
  • database.table
  • schema.table
  1. 1. Introduction
  2. UI

Schema Explorer

https://github.com/sqlparser/sqlflow_public/blob/master/sqlflow_guide_cn.md#schema

PreviousSQLText EditorNextDiagram Panel

Last updated 2 years ago

Schema Explorer Basic

Visualize SQL schema by choosing any elements

There are three modes(the mode field in json) to display the response returned by graph AP which are represented by three different colors:

  • global: Display the selected item data lineage. (default mode. You can also select an unit and right click thevisualize / visualize with columns to start this mode)

  • ignore record: Ignore the record set. Given a->b->c, show a->c. Choose to left most or to left most with columns to use this mode.

The green icons of ANALYTICS and ENTITY indicat that the mode is global;

The black icons of DATAMART indicat that the mode is summary;

The gray icons of other nodes indicat that the nodes are not visualized.

Visualization Control

You may find following elements when right click on the database/schema/table/column elements in the schema explorer:

visualize

visualize: Generate the selected db elements(could be a database/schema/table/column etc) data lineage.

visualize with cloumns

In above screenshot only the selected customer_id column related data lineage is displayed.

visualize with cloumns: Generate the selected db elements(could be a database/schema/table etc) data lineage with column details.

to left most

to left most: Generate the selected db elements(could be a database/schema/table/column etc) data lineage without the record set. (given a->b->c, show a->c )

to left most with columns

to left most with columns: Generate the selected db elements(could be a database/schema/table/column etc) data lineage with the column details but without the record set.

copy

copy: copy the element name so that we can quickly search the elements with the similar name.

to upstream/to downstream

to upstream/to downstream step by step

to upstream/to downstream step by step: Enable collapse/expend function of the intermediate detail steps when processing to upstream/to downstream so user can get a more clear view for the complex data lineage.

View DDL(Data Definition Language)

You can check the DDL for packages and procedures by right clicking on the correspondant object and choose view DDL.

Note: we are currently unable to have visualize and view DDL in stored procedures for the regular jobs who fails in retrieving metadata. Check following captures:

While you should be able to have visualize/view DDL/share under stored procedures unit in other cases.

Different Schema Structures

database.schema.table

For the databases which contain database layer and the schema layer (SQL Server for example)

For MSSQL, we have Database layer as well as Schema layer. The two layers will be both displayed on the schema UI.

database.table

For the databases which contain database layer only (MYSQL for example)

For MYSQL, we have Database layer but we do not have Schema layer. Schema is same as Database for MYSQL. Only Database layer is displayed on the schema UI.

schema.table

We would have Schema layer but there is no Database layer for this kind of DB. Only Schema layer is displayed on the schema UI.

summay: Only database, schema, table, view data and the number of above DB units will be returned if the number is more than 1,000. (check more details )

Hint: this feature only works in

Hint: this feature only works in

to upstream/to downstream: When going through lineage detail for a , we also have the choice to display the selected element in Upstream and Downstream analysis.(given a->b->c, Upstream: a->b, Downstream: b->c)

The tree structure in schema section may differ from the database types (check to find why it can be different). Same as the database, the tree strecture also has three different cases.

For the databases who contain the Schema layer only. Currently we don't have any databases which belong to this type on . If in future we have such kind of database, the structure would only contain server and schema

here
regular Job
regular Job
regular job
here
our support list