Question

A retail analytics team loads daily sales events into a BigQuery table partitioned by ingestion date. Compliance requires that only the last 90 days of detailed event data be queryable, and older data should be automatically removed to control storage cost without manual cleanup jobs. Analysts still run frequent queries filtered on the event date. What is the most operationally efficient way to meet this requirement?

Accepted Answer

Set a partition expiration of 90 days on the partitioned table so BigQuery automatically deletes partitions older than the threshold.

Answer

Schedule a daily Cloud Composer DAG that runs a DELETE statement removing rows older than 90 days.

Answer

Create an authorized view that filters to the last 90 days and revoke access to the base table.

Answer

Export partitions older than 90 days to Cloud Storage nightly and truncate the table.