Medium | Swipe Insight

How to Save 90% on BigQuery Storage Costs by Changing Default Configurations

11 months ago

Yerachmiel Feltzman, a senior Big Data Engineer at Tikal, reduced BigQuery storage costs by 90% for a client by changing a default configuration. BigQuery's time travel feature, enabled by default, can increase storage costs. Switching the storage billing model to physical bytes and reducing the time travel window to two days helped achieve these savings. Feltzman also discusses assessing cost savings and the necessity of time travel.

Tired of spending too much time creating audits for your clients?

Featured

Marketing Auditor simplifies your audit process, letting you generate comprehensive, white-label reports in just a few clicks. Save over 10 hours per report while analyzing 200+ data points and delivering 50+ pages of actionable insights. Customize reports with professional themes or your own branding, and export them in editable formats like PowerPoint or Google Slides to showcase your expertise.

Pinterest: The Field Guide to Non-Engagement Signals

1 years ago

Pinterest, with UC Berkeley and the Integrity Institute, has created a 'Field Guide to Non-Engagement Signals'. It helps platforms balance user engagement with content quality. Non-Engagement Signals, from in-app surveys and content assessments, aid in aligning with user values and improving content ranking. The guide also discusses Generative AI for scaling content quality signals and user retention strategies.