Google improved BigQuery Workload Management

Better Autoscaling and Capacity Management

Photo by Kevin Wang on Unsplash

Scaling and capacity management is a very important feature of (SaaS) Data Warehouse — here Google makes BigQuery now even more powerful.

Google updated the workload management which now provides the following benefits[1][2]:

• The autoscaler now scales up immediately.
• The autoscaler now scales more precisely.
• The autoscaler scales to the nearest multiple of 50 slots, instead of 100.
• You can now purchase capacity commitments, set baseline slots, and set autoscale max slots in incremental steps of 50 slots.
• If one minute or more has passed since the most recent increase in capacity, you can now reduce capacity without resetting the one minute minimum. This allows for multiple consecutive decreases without a one minute delay between them.

The cool thing is that Google made these new features already generally available so you can use them for productive environments.