Stack Overflow
Stack Overflow

Questions tagged [google-bi-engine]

Google BigQuery BI Engine is an in-memory analysis service as part of Google Cloud which allows for querying data stored in Google BigQuery with high performance and concurrency.

Google BigQuery BI Engine is an in-memory analysis service as part of Google Cloud which allows for querying data stored in Google BigQuery with high performance and concurrency.

24 questions
0
votes
1 answer

Mixing Big and Small Table processing in Bigquery BI Engine ? How long does BI Engine Cache the data?

Is it recommended to separate the projects that's used for ETL purpose ( Aggregating > 1TB data into a Table) and ( Querying data < 1TB ) Visualization Purpose. Or will the BI Engine smartly does this? How long will BI Engine cache queried data if…
Anthony Liu
  • 343
  • 1
  • 12
0
votes
2 answers

BI Engine on GCP

I am not able to find any way to use BI Engine outside Looker. Is there an API for BI Engine on top of Big Query so that it can be used with Python or any other language client?
RedMess
  • 11
  • 5
0
votes
0 answers

BI Engine is disabled, but chart shows "Accelerated by BI Engine" and shows no data

GDS says no data for existing data source and showing icon that is accelerated by BI Engine, but BI Engine reservation was removed 2 months ago and data is available in GBQ. Changing somehow existing data source in GDS doesn’t help. Enabling,…
MIkhail Barsukov
  • 1
0
votes
1 answer

Sample query using public data to test Bi engine Views in Google Datastudio

Since the update on 20 Feb, BI engine is supposed to support Bigquery Views in Datastudio, I tried using my own data and so far mixed success. For example a left join never worked, only aggregate using the same table seems to work. If you have BI…
Mim
  • 999
  • 10
  • 32
0
votes
1 answer

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…
mrag
  • 51
  • 3
  • 10
0
votes
1 answer

does Bigquery BI engine works with partitioned table

I have a small table in Bigquery less than 20 Mg, it is partitioned per date and has a cluster on 1 field and it does require filter Partition. when i create a reservation, and connect using datastudio, I get the error is that the query is not…
Mim
  • 999
  • 10
  • 32
0
votes
1 answer

Google BigQuery BI Engine - cross projects query analytics - which project should I add the BI Engine

I have access to both Project A and Project B. BigQuery datasets are saved in Project A. The BigQuery Analytics are done in Project B. We haver some BigQuery Views set up in Project B (but querying on data in Project A), and Google Data Studio's…
searain
  • 3,143
  • 6
  • 28
  • 60
-1
votes
1 answer

Warning "Not accelerated by BigQuery BI Engine"

I'm using GCP BigQuery with Google Data Studio. I did setup the BI engine reservation in the same region as the dataset (EU, multiple locations). I still get in Data Studio this warning: "Not accelerated by BigQuery BI Engine"
Gil Adani
  • 7
  • 2
-1
votes
1 answer

BigQuery: Is there any solution to integrate a BigQuery BI engine to BigQuery Client?

We have a use case for low latency solutions to power our custom dashboard and leverage the BI engine. I could see that the BI engine is enabled only for Data Studio and Looker. Is there any solution to integrate a BigQuery BI engine to BigQuery…
Ravi Teja
  • 35
  • 4
1
2