Hevo Managed Google BigQuery

Do not have a BigQuery Destination set up yet? No worries. For Pipelines created with the following Sources, Hevo provides a fully-managed, pre-configured Google BigQuery data warehouse to enable you to create your Pipelines without a hitch. The managed BigQuery data warehouse offers all the usual Destination operations. You can also integrate your managed BigQuery data warehouse with any BI tool of your choice. Read Connecting BI Tools. Contact Hevo Support via Intercom, if you do not find your BI tool in the list.

List of Sources:

  • Amplitude Analytics
  • Facebook Ads
  • Freshdesk
  • FTP
  • Google Adwords
  • Google Analytics
  • Google Campaign Manager
  • Google Drive
  • Google Play Console
  • Google Search Console
  • Google Sheets
  • Hubspot
  • Intercom
  • Intercom Webhook
  • Jira Cloud
  • Mailchimp
  • Mailchimp Webhook
  • Marketo
  • Rest API
  • Sendgrid
  • Sendgrid Webhook
  • Shopify
  • Shopify Webhook
  • Stripe
  • Twitter Ads
  • Zendesk

With the managed BigQuery data warehouse, replicating your Source data and building reports for your SaaS applications is as easy as:

  1. Signing up on Hevo,

  2. Accessing your data Source using Hevo Pipelines, and

  3. Writing SQL queries on the replicated data or connecting your BI tool such as Tableau, Looker, or Google Data Studio to the managed warehouse.

Limitations

  • Your email ID and domain must be associated with an active Google, G Suite, or Google Cloud Identity account.

Setting up your Managed BigQuery Data Warehouse

Note: The option to set up the managed BigQuery data warehouse is displayed only till the time you create your first managed data warehouse Destination, or if you delete an existing managed data warehouse Destination.

To set up the managed BigQuery data warehouse Destination:

1. Navigate to the Add Destination page:

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

2. Select your managed BigQuery data warehouse:

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

    Setup 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.

Pricing

The managed BigQuery data warehouse is free for Trial users. Subsequently. you can choose to continue using the same data warehouse. In that case, you are charged the cost that Hevo incurs for your project in Google BigQuery. The invoice is generated at the end of each month and payment is recovered as per the payment instrument you have set up.

Read

Last updated on 21 Oct 2020