Skip to content

Latest commit

 

History

History
32 lines (24 loc) · 1.91 KB

README.md

File metadata and controls

32 lines (24 loc) · 1.91 KB
Raw

bi-engine-statistics

a opinionated bi engine statistics dashboard for datastudio, to monitor and optimize your BI Engine workloads.

Screenshot 2022-06-15 at 11 49 01

Getting started

Prerequisites

In order to create the dashboard and query the INFORMATION_SCHEMA tables a user must have access to the following INFORMATION_SCHEMA table: INFORMATION_SCHEMA.JOBS_BY_PROJECT

Datasource

1.1 Copy the datasource

Log in to Data Studio and create a copy of the data source . More information on copying data sources can be found here1.

1.2 Set the correct GCP Billing project

Set it to the project, where you have made the BI Engine reservation.

1.3 Modify the data source:

We used region-eu in our example, however you can modify this to a region of your choice (where your BI Engine capacity is reserved). Use the following format to specify regionality for the project-id, region, and views in the INFORMATION_SCHEMA view2:

`PROJECT_ID`.`region-REGION_NAME`.INFORMATION_SCHEMA.JOBS_BY_PROJECT

Dashboard

2.1 Copy the dashboard

Create a copy of the public dashboard. You will be asked to select a new Datasource, you have to select the one you copied in step 1. Click on create report and rename it as desired.

2.2 Modify the dashboard

Once the report is copied and all of the data is rendered, you can change the dashboard to your desire. Like default-daterange, colours, logos...

Footnotes

  1. https://support.google.com/datastudio/answer/7421646?hl=en&ref_topic=6370331 ↩

  2. https://cloud.google.com/bigquery/docs/bi-engine-sql-interface-overview#acceleration_statistics_in_information_schema ↩