Using Preferred Tables in Google BigQuery
How Google updated the BI Engine
Not long ago Google announced that BigQuery BI Engine support for all BI and custom applications was available. Now they launched the Preferred Tables feature in BigQuery BI Engine.
What is the BigQuery BI Engine?
The BigQuery BI Engine is a fast in-memory analytics service. You can analyze data stored in BigQuery with a response time of less than one second and with high parallelism. When you connect Data Studio to a BigQuery table managed through BI Engine, reports and exploratory data analysis can be accelerated. Data Studio users get up to 1 GB of free capacity in BI Engine [1]. In addition to its own solution, Data Studio, looker, Tableau or Qlik can also be used with it.
How to use the new Preferred Table Feature?
You can now use the BI Engine preferred tables feature to limit BI Engine acceleration to a specified set of tables, while queries to all other tables use regular BigQuery slots. With preferred tables you can e.g. accelerate only the tables and dashboards that you identify as important…