Connecting Metabase to Hevo

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

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

Last updated on 06 Oct 2020