This is a dedicated watch page for a single video.
You have a requirement to run a BigQuery query every hour that aggregates data from a table with streaming data, storing the results in another table for reporting. The query should run automatically and the results should be retained for one week before being deleted. Which approach best meets these requirements?