Introducing the New Snowplow BigQuery Loader: Lower Costs, Better Schema Evolution, and Multi-Cloud Support
Blog post from Snowplow
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.