Home / Companies / Snowplow / Blog / Post Details
Content Deep Dive

Introducing the New Snowplow BigQuery Loader: Lower Costs, Better Schema Evolution, and Multi-Cloud Support

Blog post from Snowplow

Post Details
Company
Date Published
Author
John Bourous
Word Count
580
Language
English
Hacker News Points
-
Summary

The new BigQuery Loader for Snowplow BDP Cloud offers enhanced performance, cost efficiency, and flexibility by enabling BigQuery as a destination across both AWS and GCP platforms. This update introduces the use of BigQuery Storage Write API, reducing infrastructure costs compared to the previous Streaming Inserts API, and employs a smarter schema evolution approach that minimizes column additions and avoids BigQuery's column limit. Users will benefit from a seamless migration process, with existing Snowplow BDP customers automatically upgraded and new users able to easily deploy the loader themselves. Additionally, the loader supports handling failed events by storing them separately in BigQuery for improved visibility and debugging. Snowplow encourages users to explore the benefits of this scalable and cost-effective solution, providing extensive documentation and support for those transitioning or starting fresh with BigQuery destinations.