[SQL] Extract/Get the table name and their respective columns used in a view from a query in...

Let us take the following MYSQL query written in BigQuery for creating a view.

SELECT a.col1,
a.col2,
a.col3,
b.col1,
b.col2,
b.col3,
c.col1,
c.col2
FROM project_name_dataset_table_a a
INNER JOIN project_name_dataset_table_b b ON a.col1 = b.col1
INNER JOIN project_name_dataset_table_c c ON a.col2 = c.col2


Below is the required output format or similar. Final Format Required or any similar will be fine

Basically i have to prepare a document which will contain all the information of the views created and the tables and their respective columns used in it.

Continue reading...