Use Google BigQuery in Re:dash

Before running the commands shown on this page, you should load the Bitnami stack environment by executing the installdir/use_APPNAME script (Linux and MacOS) or by clicking the shortcut in the Start Menu under “Start -> Bitnami APPNAME Stack -> Application console” (Windows). On OS X VMs, the installation directory is /opt/bitnami and OS X VM users can click the “Open Terminal” button to run commands. Learn more about the Bitnami stack environment and about OS X VMs.

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 November 22, 2018