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?! 😬
