Parse Google BQ SQL queries and get all tables referenced
In a console Google Cloud project I have several datasets with tables/views in them, so most of them have the query from which they came. I am trying to parse every single one of them to get their table dependencies. With “table dependencies” I mean the tables next to their FROM statements or JOIN statements, not returning aliases or whole subqueries/ SELECT statements.