Connect to Google BigQuery data source

The Bold Reports^® allows you to connect to a Google BigQuery data source. To do this, you can use a service account key file to securely access and query data from your Google BigQuery projects. Follow the steps below to create a service account and set up the connection:

Create a service account

1. Go to the Create Service Account page in the Google Cloud console: https://console.cloud.google.com/projectselector2/iam-admin/serviceaccounts

2. Select your project from the dropdown menu or create a new project.

3. Click Create Service Account.

4. In the Service account name field, enter a name. The Google Cloud console will automatically populate the Service account ID field based on this name. Enter a description for the Service account. For example: Service account for Quickstart. Then Click Create and Continue button.

5. To provide access to your project, grant the following role(s) to your service account: Project > Owner. Select a role, then click Continue.

   To add more roles, click on Add Another Role and select additional roles individually.

   NOTE: The role you assign determines which resources the service account can access in your project. You can revoke or grant additional roles later. In production environments, avoid assigning the Owner, Editor, or Viewer roles. Instead, assign a predefined or custom role based on your needs.

6. Click Done to finish creating the service account. Keep the browser window open—you will need it for the next step.

Create a service account key

1. In the Google Cloud Console, the created service account displayed. Click on the below highlighted icon.

   

2. Select the Manage Keys from the Actions context menu.

3. Click Add key, and then click Create new key.

   

4. Click Create. A JSON key file will be downloaded to your computer.

   

Create a Google BigQuery data source

To configure the Google BigQuery data source, follow the below steps:

1. Click the Data icon in the configuration panel.
2. In the DATA configuration panel, click on the NEW DATA button.
3. In the connection type panel, choose the Google BigQuery data source type.
4. In the Name field, specify the data source name without special characters.
5. You can provide the service account JSON data in two ways: either in inline mode or by uploading the JSON key file.

Inline

1. Choose Inline from the Type drop-down menu and specify valid service account information for the BigQuery project as a JSON object in the Inline text area.

   

2. Click Connect to proceed to the query design pane. Enter the required query and execute it. The corresponding values will be displayed in a grid for preview.

   

3. Click Finish to save the data source with a relevant name to proceed with designing the report.

   

Upload file from disk

1. Choose File from the Type drop-down menu.

2. Click the three-dot button to open the upload box. Browse for the JSON file downloaded from Create Service Account

3. Click Connect to proceed to the query design pane.

4. Enter the required query and execute it. The corresponding values will be displayed in a grid for preview.

5. Click Finish to save the data source with a relevant name to proceed with designing the report.

See also

Google BigQuery Limitations to Build Query