Summary
An uptime monitoring service faced a significant cost increase with BigQuery. By implementing DATE partitioning and clustering by user_id and website_id, along with a 90-day partition expiration, costs were reduced by 90%. This highlights the importance of effectively utilizing available tools and methods.
Deepen your knowledge
Knowledge Base
ETL Explained — Extract, Transform, Load in plain language
What is ETL? Learn how Extract, Transform, and Load works, the difference with ELT, and which tools to use. Clearly expl...
Knowledge BaseData Lakehouse Explained — The best of both worlds
What is a data lakehouse and why does it combine the best of data warehouses and data lakes? Architecture, comparison, a...