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