UPDATED 13:00 EST / APRIL 10 2019

BIG DATA

Google partners with Fivetran to bring more data to BigQuery

Google LLC teamed up with a little-known company called Fivetran Inc. today to create a new Data Transfer Service for its BigQuery data analytics platform.

BigQuery is actually a data warehouse service that’s used to store and analyze extremely large, read-only datasets. It’s hosted on Google’s cloud infrastructure and accesses data via an application program interface, but up until now it has been tricky for companies to funnel data from third-party sources to the platform.

Google’s new Data Transfer Service is designed to remedy that and make it easier for companies to use BigQuery to analyze data from more than 100 sources, such as Salesforce, Marketo and NetSuite.

Fivetran’s role is to supply the data connectors that enable the smooth and simple transfer of this information. What it does is replicate the data stored in these services, within BigQuery’s data store. Previously, companies needed to build complicated extract, transact and load pipelines in order to access outside data with BigQuery.

“Every company should have access to all their data, in one place, in real time, and Data Transfer Service is the realization of that vision,” George Fraser, Fivetran’s co-founder and chief executive officer, said in a statement. “The era of every company building fragile, error-prone custom ETL pipelines is over.”

Here’s a quick demo of how Fivetran helps enable the Data Transfer Service:

dts-salesforce-demo-video

Fivetran’s data connectors enable quite a few possibilities, the company said. Once data has been replicated inside BigQuery, customers can leverage external data science tools such as Looker and Tableau for more in-depth insights. They can also connect to Google services such as BigQueryML and CloudAutoML in order to use that data to train artificial intelligence models.

Google described Fivetran as its “launch partner” for the new Data Transfer Service, so it seems likely that it will team up with alternative data connector providers to expand the service later.

Fivetran’s data connectors are now available on the Google Cloud Platform Marketplace, with the company offering a free 14-day trial before customers commit.

Image: Fivetran/Google

Since you’re here …

Show your support for our mission with our one-click subscription to our YouTube channel (below). The more subscribers we have, the more YouTube will suggest relevant enterprise and emerging technology content to you. Thanks!

Support our mission:    >>>>>>  SUBSCRIBE NOW >>>>>>  to our YouTube channel.

… We’d also like to tell you about our mission and how you can help us fulfill it. SiliconANGLE Media Inc.’s business model is based on the intrinsic value of the content, not advertising. Unlike many online publications, we don’t have a paywall or run banner advertising, because we want to keep our journalism open, without influence or the need to chase traffic.The journalism, reporting and commentary on SiliconANGLE — along with live, unscripted video from our Silicon Valley studio and globe-trotting video teams at theCUBE — take a lot of hard work, time and money. Keeping the quality high requires the support of sponsors who are aligned with our vision of ad-free journalism content.

If you like the reporting, video interviews and other ad-free content here, please take a moment to check out a sample of the video content supported by our sponsors, tweet your support, and keep coming back to SiliconANGLE.