Here's a smell that your Big Query query ain't that big - lots of 1 row tables getting used to load config-like values, which are then used for JOINs later.
So much cruft to clean up 😥 .
My brain says: - maybe couldda just done it in a PAndAs?! Let's definitely not learn about CTEs right?! 😬
If you use BigQuery and allow others to query your data, you might be interested in my feature request:
Disallow querying for select * ...
This is a super-simple control which is useful for folks with wide tables/columns that incur significant cost on select *.
Of course it won't prevent someone listing every column but it will encourage people to think about what they're doing & adjust. https://issuetracker.google.com/u/2/issues/288391231 #BigQuery