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
5
votes
2 answers

Controlling and monitoring use of BI Engine Reservations

With the new beta BI Engine Reservations, I've noticed some queries speed up, but others remain unaffected. Will it be possible - to monitor how the reservation is being used? - to have some control over how the reservation is used?
Ian Rubenstein
  • 101
  • 5
3
votes
1 answer

Missing regions for BI Engine in BigQuery

The docs for BI Engine say that "BI Engine supports the same regions as BigQuery", yet many BigQuery regions seem to be missing when I go to use it: https://cloud.google.com/bi-engine/docs/overview#supported_regions Why aren't all the BigQuery…
Graham Polley
  • 14,393
  • 4
  • 44
  • 80
2
votes
1 answer

Logging for Google BI Engine

Is logging enabled for BI Engine? If yes can anyone point to the documentation for the same? I could only find documentation for 'Monitoring' at this link: https://cloud.google.com/bi-engine/docs/monitoring
Snehal Thorat
  • 121
  • 2
  • 8
1
vote
1 answer

BigQuery BI Engine: how to choose a good reservation size?

I am enabling BI Engine to speed up my queries and to save cost for my project in the EU region. What would be a good choice for setting the reservation size? 1GB, 2GB, 4GB? How do I make that decision?
Sander van den Oord
  • 10,986
  • 5
  • 51
  • 96
1
vote
2 answers

BigQuery - BI Engine measuring savings

I have deployed BI Engine in one of my Google projects and I am measuring cost savings using the following query with tbl as ( select creation_time, total_bytes_processed, total_bytes_billed, 5 * (total_bytes_processed /…
denim
  • 427
  • 4
  • 16
1
vote
1 answer

Data blending with BI Engine in Data Studio

Does BI Engine work for blended data sources? I don't see any icons for visualisations using blended data sources.
Norfecaz
  • 47
  • 1
  • 5
1
vote
2 answers

Google BI Engine with Data Studio performance comparison

Is there a way to turn off the BI Engine feature when using Data Studio? My goal is to compare and analyze the value add of BI Engine, like before and after using the BI Engine to accelerate the data studio charts.
Snehal Thorat
  • 121
  • 2
  • 8
1
vote
1 answer

Why BigQuery BI engine does not use all the reservation?

I have a dashboard connected to a BigQuery Table, BI engine works as expected as I am using a calendar filter and my table is partitioned per date. when I select a longer date range, BI engine stop working with this message "The table or data volume…
Mim
  • 999
  • 10
  • 32
1
vote
3 answers

Google BigQuery BI Engine monitoring and comparing

I have recently been asked to look into BI Engine for our BigQuery Tables and Views. I am trying to find out how to compare the speed of using BI Engine reservation against not using it.. any way i can see this? Thank you
Rua Col
  • 11
  • 1
1
vote
1 answer

How to ensure that BI Engine is running?

I've followed the tutorial found here https://cloud.google.com/bi-engine/docs/getting-started-data-studio I've also tried doing reservations in the region I'm using (London) for my own dataset. I did not see any difference "before" and "after", also…
avloss
  • 2,389
  • 2
  • 22
  • 26
1
vote
1 answer

Resource has been exhausted (e.g. check quota) - Google BI Engine

I am creating a reservation in google BI engine with the capacity of 2GB but it is throwing an exception of "Resource has been exhausted". However, the quota limit for the capacity in beta is 10 GB and I also checked no other resources are…
tested tested
  • 39
  • 6
0
votes
0 answers

I have added few tables in BI engine in big query. How can I be sure that it using BI engine to return result and not BIG query?

Even after that when I am querying the query is not utilizing BI engine and returns as BI engine mode as NULL. I am using the below query to check the output : SELECT creation_time, job_id, bi_engine_statistics FROM …
Ayan Chakraborty
  • 49
  • 7
0
votes
1 answer

Reservation Used Bytes parameter keeps changing

I created a dashboard in the Cloud Monitoring to monitor BI Engine metrics. I have a chart to measure the Reservation Used Bytes. The chart keeps changing values ranging from 30GB to 430MB, according to the chart. The time frame between days and…
Daniel
  • 5,095
  • 5
  • 35
  • 48
0
votes
1 answer

BigQuery with BI Engine is slower than BigQuery with cache

I've read almost all the threads about how to improve BigQuery performance, to retrieve data in milliseconds or at least under a second. I decided to use BI Engine for the purpose because it has seamless integration without code changes, it supports…
Borislav Gizdov
  • 1,323
  • 12
  • 22
0
votes
1 answer

BI Engine mode is partial and the reason is due to internal errror

I created a reservation for BI Engine to make the reports on Google datastudio load faster. I create a query and save it as view. I looked at the job information and it says "unable to support input table due to an internal error". What does it…
Kit Lactuan
  • 9
  • 3
1
2