Good News: More Power for Google BigQuery Analytics

BigQuery BI Engine now supports more BI Software and Apps

Christianlauer
CodeX
Published in
2 min readMay 12, 2022

--

Photo by Hoover Tung on Unsplash

While the BI engine was first reserved for Data Studio users, there is now interesting news for other tools as well.

What was the BI Engine again?

BigQuery BI Engine is a fast in-memory analytics service. Using BI Engine, you can analyze data stored in BigQuery with a response time of less than one second while saving computing costs. BigQuery BI Engine enhances your dashboards in two ways [1]:

  • The BI Engine SQL interface is a distributed in-memory engine that accelerates any BigQuery query, regardless of the API used. Any tool that works with BigQuery interfaces such as BigQuery SQL, API, and client libraries or JDBC drivers will also work with the BI Engine SQL interface. BI Engine SQL interface provides additional statistics and monitoring by scaling to large data sizes with distributed execution and partial acceleration.
  • Google Data Studio acceleration, with which BI Engine delivers interactive performance.

Advantages of the BI Engine

The engine provides the following concrete benefits for customers and, of course, end users:

  • Fast result — nobody wants to struggle with slow dashboards and outdated data.
  • Simplified architecture: get started quickly without managing complex data pipelines or servers
  • User-friendliness: Seamless interactions in BigQuery
  • Smart Tuning: Easy to set up and very few configuration settings

New Supported BI Tools

With the BI Engine you can get now more performance for your queries across all BI tools that connect with BigQuery, thereby helping them leverage existing investments and get a better user experience.

Example of Supported BI Tools — Source: Google[1]

Of course, in addition to Data Studio, Google now offers it primarily for internal products such as Google Sheets and Looker and is likely to have again rise the…

--

--

Christianlauer
CodeX
Editor for

Big Data Enthusiast based in Hamburg and Kiel. Thankful if you would support my writing via: https://christianlauer90.medium.com/membership