QuestionQ79

VerifiedStoring the data

You work for an airline and must store weather data in a BigQuery table. The weather data will serve as input to a machine learning model. The model uses only the most recent 30 days of weather data. You want to avoid retaining unneeded data and minimize costs. What should you do?

Explanation

A time-unit column-partitioned BigQuery table can be partitioned by the weather-date DATETIME value, and a 30-day partition expiration automatically deletes each partition based on its partition boundary. This aligns retention with the dates the model uses and removes obsolete data without scheduled deletion queries.

Learn more

Community Discussion

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