I need to find the complex SQL statement based on the best practices of Bigquery inside a large SQL file which contains more than 1000 lines of query. How can I do this?
I tried REGEX to find the pattern of JOINS, Sub Queries, Unions etc. But in a single line statement, a single JOIN wont be considered as a complex thing. So how can I find whether the Join in a statement is will lead to a complex computation or not?
New contributor
Nagul Pranav V S is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.