1

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 was larger than BI Engine supports at this time", that's fair.

Please notice, I am already filtering by a partition, but sometimes, I need to see the whole data

to solve that, I created a BI reservation, and I notice regardless of the size 1,2,4 GB the memory used is always 600MB? and I get the same message, I attached a screenshot here, is this by design?

enter image description here

Bug Report here: https://issuetracker.google.com/issues/150633500

Seyedraouf Modarresi
  • 1,213
  • 9
  • 14
Mim
  • 999
  • 10
  • 32

1 Answers1

1

turn out the error is not related to reservation, but to the fact that BI engine support only 500 partition, my table has more

https://cloud.google.com/bi-engine/docs/overview#limitations

the solution is instead of partition per day, I will use something like week or month

Mim
  • 999
  • 10
  • 32