bigquery-utils icon indicating copy to clipboard operation
bigquery-utils copied to clipboard

compute ddl script

Open afleisc opened this issue 1 year ago • 0 comments

closes #459

It can be more cost efficient to use either the on-demand or the reservation compute billing model depending on query patterns. This script aims to identify projects that obviously save cost by switching billing models and to provide template DDL to adjust accordingly.

The logic is essentially:

1.) on-demand -> reservations

Compare the on-demand cost to the worst case cost in reservations (all autoscaling). If autoscaling is less expensive, move to reservations.

2.) reservations -> on-demand

Compare the best case scenario for reservations (all baseline) to on-demand cost. If on-demand is less expensive, move to on-demand.

afleisc avatar Oct 02 '24 20:10 afleisc