## Metadata - Author: [[yerachmiel-feltzman|Yerachmiel Feltzman]] - Full Title:: How to Save 90% of BigQuery’s Storage Cost - Category:: #🗞️Articles - Document Tags:: [[bigquery|Bigquery]], - URL:: https://www.blef.fr/r/2d6b4cbd?m=110e62bb-0c8f-4516-ae23-b43d96d3f9ac - Finished date:: [[2024-08-18]] ## Highlights > 1. Set billing mode to physical, so we pay for only what we store: > ALTER SCHEMA my_landing_zone > SET OPTIONS( > storage_billing_model = 'PHYSICAL'); > 2. Reduce time travel to the minimum ([two days](https://cloud.google.com/bigquery/docs/time-travel#configure_the_time_travel_window) by the time I wrote this article): ([View Highlight](https://read.readwise.io/read/01j5j70sz11zdxt25zyhjrb9ps))