Warning "Not accelerated by BigQuery BI Engine"

Question

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"

Answer 1

BI Engine accelerates only some types of queries. See some limitations documented here.

Go to your BigQuery console, locate the project history, and the Jobs history, filter to Querys only.

Examine each query that is coming from DataStudio, and if you open the pane, it will have details why it's not accelerating it.

You will see samples like this:

If you are more developer friendly you can use the BQ cli command tool

To get the most recent jobs:

bq  ls -j -a --max_results=15

To fetch the statistics associated with BI Engine accelerated queries, run the following bq command-line tool command:

bq show --format=prettyjson -j job_id

and it will have a section such as:

"statistics": {
    "creationTime": "1602175128902",
    "endTime": "1602175130700",
    "query": {
      "biEngineStatistics": {
        "biEngineMode": "DISABLED",
        "biEngineReasons": [
          {
            "code": "UNSUPPORTED_SQL_TEXT",
            "message": "Detected unsupported join type"
          }
        ]
      },