Change billing model
See: BigQuery storage billing models, logical vs physical (compressed)
- 24H for change to take effect.
- 14D before changing the storage billing model.
ALTER SCHEMA DATASET_NAME
SET OPTIONS(storage_billing_model = 'BILLING_MODEL');
-- Billing model LOGICAL or PHYSICALReferences
Update dataset properties | BigQuery. [Online]. Available at: https://cloud.google.com/bigquery/docs/updating-datasets#bq [Accessed 8 May 2025].