This is a dedicated watch page for a single video.
You possess historical data spanning three years stored in BigQuery, alongside a data pipeline delivering fresh data to BigQuery daily. Upon observation, you've noted that queries performed by the Data Science team, filtering on a date column and confined to a 30 to 90-day window, result in full table scans, leading to unexpected increases in your bill. Your objective is to address this issue in a cost-effective manner while retaining the ability to execute SQL queries. What is the most suitable course of action?