Connecting Metabase 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 Metabase to your managed BigQuery data warehouse.

Prerequisites

  • Metabase version 0.36.0 or higher, to enable the option to upload login credentials through a JSON file.

  • An active Metabase account with admin privileges.

  • Metabase connection settings downloaded from Hevo.


Steps

  1. Log in to your Metabase account.

  2. Click Settings (gear icon) in the top right corner of the screen, and then, Admin.

    Metabase Admin menu

  3. Click Databases in the Admin menu, and then, Add database.

    Add Database option

  4. In the page that is displayed, specify the following:

    Metabase settings for BigQuery

    Note: The values provided in the image are indicative.

    1. Database type: BigQuery

    2. Name: A suitable name for your BigQuery database. For example, Hevo-BQWH.

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

    4. Service account JSON file: Click Select a file to attach the JSON file having the connection settings, which you downloaded from Hevo.

  5. Click Save to connect to your managed BigQuery data warehouse.

  6. In the dialog that appears, click any of the tables to start visualizing your data. Alternatively, click I’m done exploring for now, to do this later.

Tell us what went wrong