CODEWITHSUNDEEP
google-bigquerylooker-studiogoogle-bi-engine
Kit Lactuan
Kit Lactuan

Reputation: 9

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 mean?

1

Upvotes: 0

Views: 951

Answers (1)

Alexey Klishin
Alexey Klishin

Reputation: 184

One of your tables is defined as external table (references a spreadsheet). Unfortunately BI Engine only supports tables that are stored in BigQuery natively today. We will work on improving the error message in this case. Supporting external tables was not on our roadmap so far, unfortunately.

To get full BI Engine acceleration, please load the data from spreadsheet into BigQuery.

See BI Engine overview here: https://cloud.google.com/bi-engine/docs/introduction

Upvotes: 0

Related Questions