CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquerylooker-studiogoogle-bi-engine
mrag
mrag

Reputation: 81

Can I use BI Engine to speed up left outer joins in Google Data Studio?

I currently need to blend two data sources (two distinct BigQuery tables) in Google Data Studio which means every time a report filter selection is updated, Data Studio needs to re-compute the left outer join on the fly (or at least it looks as if it is because it takes ages to load). I was reading about BI Engine and wondered if that could be useful for this use case in speeding up left outer joins in Data Studio?

https://cloud.google.com/bi-engine/docs/getting-started-data-studio

Upvotes: 0

Views: 454

Answers (1)

Minhaz Kazi
Minhaz Kazi

Reputation: 3168

Yes, it should be.

For this use case, you should create a new view in BigQuery that joins the two tables. Then query that view directly from Data Studio. The guide you linked to has information on how to enable BigQuery BI Engine for your GCP project.

Upvotes: 1

Related Questions