Your organization uses a BigQuery table that is partitioned by ingestion time. You need to remove data that is older than one year to reduce your…

Setting the table partition expiration period to one year using the ALTER TABLE statement is the most

efficient and cost-effective approach. This automatically deletes data in partitions older than one

year, reducing storage costs without requiring manual intervention or additional queries. It

minimizes administrative overhead and ensures compliance with your data retention policy while

optimizing storage usage in BigQuery.

Extract from Google Documentation: From "Managing Partitioned Tables in BigQuery"

(https://cloud.google.com/bigquery/docs/partitioned-tables#expiration): "Set a partition expiration

time using ALTER TABLE to automatically remove partitions older than a specified duration, reducing

storage costs efficiently for ingestion-time partitioned tables."

Reference: Google Cloud Documentation - "BigQuery Partitioned Tables"

(https://cloud.google.com/bigquery/docs/partitioned-tables).