Connecting Google Data Studio to Hevo

Last updated on Feb 21, 2022

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

    * 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