Skip to content

a opinionated bi engine statistics dashboard for dashboard

License

Notifications You must be signed in to change notification settings

doitintl/bi-engine-statistics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

13 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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

About

a opinionated bi engine statistics dashboard for dashboard

Resources

License

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages