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.
-
On the “Create service account” page, type a name for the service account.
-
Give the service account “Viewer” permissions on the project.
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.
-
Enter the “Project ID” (this is the Google Cloud Platform project ID) and upload your JSON Key File, generated when creating a service account.
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.