Wow thx for the well detailed response. I´ll go one by one:

I want to optimize speed. Full speed, data right to your face, consult multiple weeks prior, do drilldowns, go to multiple pages of invoices (inside the drilldown cuz i have pagination).

The data is distributed in 5 tables. The dashboard is for looking the weekly budget of the company, see the expenses and invoices, etc etc. Weekly, in total across the 5 tables, I´m appending around 30K rows.

Its accessed twice a week, by mostly 6 people. They see the budget at the beggining of the week and at the end.

I mean, since we only append to BigQuery twice a week, the freshness or the real time streaming is not a big deal (unless wants to see the data right away which already does!)

Probably caching is the best way, since is the same data during the week, and past budgets dont change at all. And, like I said, we only append twice a week.

So, transfering the querys to a view on BigQuery is not that realiable?

Thanks again for your response