virtualMachineredash

Use Google BigQuery in Re:dash

Re:dash has multiple supported data sources and one of them is Google BigQuery.

If your application doesn’t run on Google App Engine or Google Compute Engine, you must first obtain service account credentials in the Google Developers Console. To generate service account credentials, do the following:

  • Go to the Google Developer Console for your project.

  • Select the “IAM & admin -> Service accounts” section. Click the “Create service account” button.

    Service account creation

  • On the “Create service account” page, type a name for the service account.

    Service account creation

  • Give the service account “Viewer” permissions on the project.

    Service account permissions

The next step is to add the data source to Re:dash, as follows:

  • Log in to Re:dash and from the dashboard, click the “New Data Source” button.

  • Select “BigQuery” as the data source type.

    Data source creation

  • Enter the “Project ID” (this is the Google Cloud Platform project ID) and upload your JSON Key File, generated when creating a service account.

    Data source configuration

Finally, insert a query as described below:

  • Create a dataset in Google BigQuery (see BigQuery Web UI Quickstart).
  • Log in to Re:dash and click “Create -> Query”. Select your dataset as Data Source and “Execute” the query.
Last modification December 21, 2022