Whether your goal is to leverage the newest technology or to stay up to date with your Oracle ERP, migrating to the cloud is a complex, but worthwhile undertaking. It requires time to install, train, and embed new processes, but the effort is rewarded by the ability to leverage more agile workflows and increase ROI. Although many companies run their own on-premise servers to maintain IT infrastructure, 48% of organizations already store data on the public cloud.
With Fivetran webhooks, developers can use real-time messages to power user experiences, transform data, drive error alerting and more.
BigQuery's Remote Functions (in preview) make it possible to apply custom cloud functions to your warehouse without moving data or managing compute. This flexibility unlocks many use cases including data enrichment. In this post we demonstrate a pattern for combining BigQuery with the Google Maps API to add drive times to datasets containing origin and destination locations. This enrichment pattern is easily adapted for address geocoding or adding Google Map's place descriptions to locations.