Python script to control BI Engine Reservations

Posted on Sat 07 May 2022 in Google BigQuery

I wrote a small Python script to be able to create and delete BI Engine reservations for Google Cloud BigQuery. I used this script in a cronjob to disable BI Engine on the weekends/during the nights to save some costs and see how well the system is with and without pre-warmed caches. To run it you need to install the google-cloud-bigquery-reservation library.