Yeah I agree with you wouldn't want to point a dashboard directly at BigQuery. There are two cases here: - You don't need realtime data, but you want to serve

Yeah I agree with you wouldn't want to point a dashboard directly at BigQuery. There are two cases here: - You don't need realtime data, but you want to serve the data quickly. If you wanted to use Bigquery in this case, you'd have the query running on some schedule, and then store and serve the results from whatever data store you like. This is what most dashboarding tools are doing under the hood (e.g. Mode, Metabase, etc.) - If you need real or near real-time data, then an OLAP system like Clickhouse makes a lot of sense! I'm definitely not trying to say that BigQuery is right for every situation. It's more that there are very few situations that I can see Postgres being the best workhorse for your analytics.