Systems | Development | Analytics | API | Testing

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.

As an engaged member of the AWS community, we’re always on the lookout for new technologies and software tools that can help our customers succeed in their AWS data lake initiatives. During the most recent AWS Re:Invent conference in Las Vegas, we had the opportunity to engage directly with AWS partners, customers, and other technology companies operating in the AWS ecosystem.

Ignorance is bliss. But not so much if it’s costing you money, right? If you are running an eCommerce business and are still not leveraging data to make data-informed decisions, you are missing out on crucial insights that can maximize your sales and minimize costs. One of the common misconceptions is that becoming a more data-driven company is complicated, difficult, and will cost a lot of money. This can be true, but there is also a better way.

The reasons for writing reports in business are pretty compelling. Without them, you can’t have a complete overview of any past periods to evaluate your performance, fix mistakes, and replicate strategies that helped you achieve your goals. Moreover, you get to plan for the future and create an actionable plan based on the data you collected and presented in a report.

Five things to know about data integration for B2B ecommerce: Business-to-business (B2B) ecommerce companies share many of the same data integration obstacles as their business-to-consumer (B2C) counterparts—managing multiple data types, abiding by data governance guidelines, merging data with partners, etc. Still, many data integration solutions cater specifically to ecommerce enterprises in the B2C space, so integrating data remains a challenge for the B2B sector.

Here are five things to know about processing unstructured data: Unstructured data is big. Really big. According to an MIT Sloan School of Management study, 80-90 percent of data is unstructured information such as photos, text, audio, emails, and social media posts. This should come as no surprise to e-commerce retailers who collect and store unstructured data from invoices, online product reviews, sales presentations, and chatbot conversations with customers.

Today we are announcing the Preview of BigQuery Remote Functions. Remote Functions are user-defined functions (UDF) that let you extend BigQuery SQL with your own custom code, written and hosted in Cloud Functions, Google Cloud’s scalable pay-as-you-go functions as a service. A remote UDF accepts columns from BigQuery as input, performs actions on that input using a Cloud Function, and returns the result of those actions as a value in the query result.

Global research reveals that 77% of enterprises lack real-time access to ERP data, leading to poor business outcomes and lost revenue.

Learn what data literacy is, why it’s important, and the 7 expert ways you can improve your team’s data literacy skills today.