Hevo Managed Google BigQuery

Last updated on Aug 18, 2023

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:

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:

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

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


Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Aug-18-2023 NA Updated the page overview to list the supported Sources only.
Aug-10-2023 NA Updated the page to list supported Sources only.
Jul-25-2023 NA Updated the page to improve the readability.
Jul-14-2021 NA Updated the list of Sources for which Hevo offers a fully managed data warehouse Destination.

Tell us what went wrong