Cloud Data Warehouse
Supports global data loads from Google Cloud Storage, Google Cloud Datastore, or streamed from third-party storage systems so teams can load, encrypt, replicate, and protect data in one data warehouse
Automates data movement from third-party platforms like Looker, Tableau, Google Analytics 360 Suite, and SnapLogic
Supports pay-as-you-go or flat-rate prices so teams can scale data storage usage
How BigQuery works
If only getting your customer data into BigQuery were as simple as spinning up a new cluster.
The goal of a data warehouse is to pull in all relevant data from the various places your customers generate it. Exporting data from your various cloud apps like Salesforce and Zendesk means writing a custom ETL process that pulls data from export APIs or paying for enterprise ETL solutions. Getting web and mobile analytics data into BigQuery is even harder. Your options are more custom ETL work from your analytics tools or spending a lot of time getting open source options to work.
Get more out of BigQuery with Segment
When you connect a BigQuery warehouse to Segment, your analytics data from web and mobile is loaded automatically. The data schema is easy to understand and ready to power SQL queries and BI tools without any additional admin work. You can connect a growing number of cloud app data sources in Segment to instantly kick off an ETL process from tools like Salesforce, Stripe, and Zendesk into your BigQuery cluster. That data can be joined with web and mobile data to power advanced analysis work without custom data engineering or ETL pipelines required.