Identifying the Dependency Automatically on the SQL Statements

Phani1 — Tue, 04 Jun 2024 11:10:38 GMT

Hi All,

We have a SQL script file with lots of create, insert, and SQL statements. We need to figure out how to identify the dependencies between the statements dynamically(by using either spark/sql or using any program).

For example - First, we need to run the "create table1" command.
After that, we can create "table2" by selecting all the data from "table1".
Then, we have to insert data into table3 that relay on "table1" and "table2"

Regards,

Janga

topic Identifying the Dependency Automatically on the SQL Statements in Get Started Discussions

Identifying the Dependency Automatically on the SQL Statements