@Noah
Another amateur question incoming:
So, the script you shared, it pulls data from partitioned tables of BigQuery, transforms them into a single holistic table, and connects it to Looker Studio for visualization. Am I right?
So by easier/faster to query, you mean by using looker studio, we can query only the data we want? That's how query faster and save some money?
And one more question, would the looker studio report run whenever a client refreshes?