This is a dedicated watch page for a single video.
You are working for AgriSense Ltd , a smart farming company. You manage a BigQuery table named sensors , which is about 500 MB in size and contains metadata for 5,000 sensors —with columns for id , name , and location . This table is updated hourly . Each sensor emits a metric every 30 seconds , along with a timestamp, and you want to store these metrics in BigQuery . The goal is to run an analytical query once a week for monitoring purposes, while minimizing costs . What is the most appropriate data model?