QuestionQ98

VerifiedData Management

Your organization has a BigQuery table partitioned by ingestion time. You need to delete data older than one year to lower your organization’s storage costs. You want to use the most efficient approach while minimizing cost. What should you do?

Explanation

A one-year partition expiration automatically deletes whole partitions after they reach that age. Updating this setting with ALTER TABLE ... SET OPTIONS applies it to the table’s partitions, and existing partitions older than the new expiration can expire immediately. This avoids recurring update work and actually removes storage rather than only filtering rows from query results.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!