Show call relationship
The "Show Call Relationship" feature allows users to automatically generate a detailed SQL procedure invocation relationship diagram. By visualizing how different procedures call and interact with each other, users can gain deeper insights into complex stored procedures and their dependencies.
In Editor mode, click the following button to get the call relation
Under Job mode, right click the data source and choose "show call relationship" to visualize the invocations
Use Cases:
Tracking Procedure Dependencies: Users can now easily track how procedures interact, making it simple to manage complex systems.
Enhancing Data Governance: This feature is especially valuable for compliance purposes, as it allows data teams to trace how SQL procedures interact across the system.
Let's take following SQL as an example:
This SQL contains a relatively complex case which involves different SQL procedure invocations, multiple procedures and functions are get invoked. Using "Show call relationship" brings us the following diagram:
The "Show Call Relationship" feature strengthens SQLFlow’s ability to analyze and manage SQL procedures, giving database administrators and developers more control and visibility into their data environments.
Last updated