Connecting Google Data Studio to Hevo

Last updated on Mar 18, 2024

Starting Release 2.20, the Hevo Managed BigQuery Destination is available only to users who have existing Pipelines with it. If you need to reauthorize or change the Google account in your existing Pipeline, you must contact Hevo Support.

Refer to this section to connect Google Data Studio to your managed BigQuery data warehouse.

Prerequisites

  • An active Google Data Studio account.

  • Google Data Studio connection settings downloaded from Hevo.


Steps

  1. Log in to the Google Data Studio application, Data Sources tab using the Google account linked to your Hevo application.

  2. Click Create in the top left on the page, and then, Data source.

    Data Studio - select Data Source

  3. If you are creating your first data source:

    1. Click GET STARTED, select the check box to agree to the Terms of Service, and click ACCEPT.

    2. Specify your preferences and click DONE.

    3. Repeat Step 2.

  4. Click BigQuery in the list of Google Connectors.

    Select Google BigQuery Source

  5. Click Authorize to allow Data Studio to connect to your BigQuery data warehouse.

  6. In the Data Source page, specify the following:

    1. Projects: The Project ID mentioned in the connection settings downloaded from Hevo.

    2. Dataset: The Dataset ID mentioned in the connection settings downloaded from Hevo.

    3. Table: The table on which you want to build the report

  7. Click CONNECT in the top right.

    Select project, dataset, and table

    Note: The values provided in the image are indicative.

  8. The Dimensions are listed based on the table schema. Click CREATE REPORT to build your report.

Create Report action

Tell us what went wrong