Hevo Managed Google BigQuery

Do not have a BigQuery Destination set up yet? No worries. Hevo provides you a fully-managed, pre-configured BigQuery data warehouse as a Destination that makes it simple for you to create a Pipeline. This data warehouse offers all the operations that the usual BigQuery Destination provides. You can integrate any BI tool of your choice with this data warehouse. Read Connecting BI Tools. If you do not find your BI tool in the list, contact Hevo Support.

Hevo supports the managed BigQuery data warehouse for the following Sources:

• AdRoll

• Amplitude Analytics

• Apple Search Ads

• Criteo

• Facebook Ads

• Facebook Pages

• Freshdesk

• FTP

• Google Ads

• Google Analytics

• Google Drive

• Google Play

• Google Search Console

• Google Sheets

• Hubspot

• Instagram Business

• Intercom App

• Intercom Webhook

• Jira Cloud

• Klaviyo

• LinkedIn Ads

• Mailchimp

• Marketo

• Microsoft Ads

• Outbrain

• Pardot

• Rest API

• Salesforce

• Salesforce Marketing Cloud

• Sendgrid

• Sendgrid Webhook

• Shopify App

• Shopify Webhook

• Stripe

• Taboola

• Twitter Ads

• Zendesk

You can replicate your Source data to the managed BigQuery warehouse and create reports for your SaaS apps by following the steps below:

1. Sign up on Hevo.

2. Create Hevo Pipelines using a Source from the above list and managed BigQuery warehouse as the Destination.

3. Do one of the following:

   • Write SQL queries on the replicated data.

   • Connect your BI tools such as Tableau, Looker, or Google Data Studio to the managed warehouse.

---

Setting up your Managed BigQuery Data Warehouse

You can set up the managed BigQuery data warehouse only if you have:

• not created your first Pipeline yet.

• not created a BigQuery Destination yet.

• deleted an existing managed warehouse Destination.

To set up the managed BigQuery data warehouse Destination:

Navigate to the Add Destination page:

• In the Pipeline creation flow, provide your data Source settings and click TEST & CONTINUE.

Select your managed BigQuery data warehouse:

1. In the Add Destination page, click SET UP WAREHOUSE.

   

2. In the Set up a Data Warehouse page, provide a name for your managed BigQuery data warehouse.

3. Click SAVE DESTINATION.

This completes the setup for your managed BigQuery data warehouse. Read Connecting BI Tools to Hevo for the steps to connect this warehouse to any BI tool.

---

Pricing

If you are a trial user, you can set up the managed BigQuery data warehouse for free. You can continue to use the same warehouse post-trial expiry as well. In such a case, Hevo charges you the cost which it incurs for your project in Google BigQuery. At the end of each month, Hevo generates the invoice and collects the payment as per the payment method you set up. Read Google BigQuery Pricing and Cloud Storage Pricing to know more about the pricing in Google.

---

Limitations

• You must link your email ID and domain to an active Google Workspace or Google Cloud Identity account.

---

See Also

• Google BigQuery Pricing
• Cloud Storage Pricing

---

Revision History