BigQuery Connector for Jira (DC)
BigQuery Connector for Jira (DC)
Breadcrumbs

Creating Service Account Key

To authenticate in BigQuery, the service account key is required. Therefore, before exporting Jira data to BigQuery, create the key in the Google Cloud console.

  • This guide will walk you through all the required steps to create a service account key.

  • You’ll start by creating a custom role with the necessary permissions, then create a service account, and finally generate the key.

  1. Open your project in the Google Cloud console, and then select IAM & Admin.

  • If you don’t have a project in the Google Cloud console, you have to create a billing one to export data.

bq_connector_for_jira_dc_custome_role_service_account_1-2.gif

  1. Select Roles, and then select + Create role.

bq_connector_for_jira_dc_custome_role_service_account_2.gif

  1. Select + Add permissions.

bq_connector_for_jira_dc_custome_role_service_account_3.gif

  1. Select the following three permissions, and then select Add.

bigquery.datasets.create
bigquery.tables.create
bigquery.tables.updateData

  • We’ve decided to stop using the Owner role to manage access and instead recommend more appropriate alternatives. You can now choose the option that works best for your setup.

The most flexible and accurate solution is to create a custom role with a specific set of permissions.

Alternatively, you can use one of the default roles with fewer permissions than Owner - such as Editor or BigQuery Data Editor - if that meets your organization’s requirements.

bq_connector_for_jira_dc_custome_role_service_account_4.gif

  1. Check added permissions, and then select Create.

bq_connector_for_jira_dc_custome_role_service_account_5.gif

  1. Select APIs & Services.

bq_connector_for_jira_dc_custome_role_service_account_6.gif

  1. Select Credentials, select +CREAT CREDENTIALS, and then select Service account.

bq_connector_for_jira_dc_custome_role_service_account_7-9.gif

  1. In the Service account name field, enter the name for your service account.

  • The Service account ID * field will be filled automatically upon entering the service name.

  1. [Optional] In the Service account description, enter the description for your service account.

  2. Select CREATE AND CONTINUE.

bq_connector_for_jira_dc_custome_role_service_account_10.gif

  1. In the Select a role field, select Custom, and then select Custom Role.

Custom Role is just a placeholder name used for demonstration purposes. You can assign any name to your custom role.

bq_connector_for_jira_dc_custome_role_service_account_11.gif

  1. There are two options:

  • Select CONTINUE if you need to share this service account and its key with someone.

  • Select DONE if there’s no need to share the service account and its key.

Each user has to create their own service account, and then generate a service account key. If you need to share your service account and key with someone, you can grant them access to the service account. If there's no need, you can skip this step.

bq_connector_for_jira_dc_custome_role_service_account_12.gif

  1. Select Manage service accounts.

bq_connector_for_jira_dc_custome_role_service_account_13.gif

  1. Find the corresponding service account, select the Actions button, and then select Manage keys.

bq_connector_for_jira_dc_custome_role_service_account_14.gif

  1. Select ADD KEY, and then select Create new key.

bq_connector_for_jira_dc_custome_role_service_account_15.gif

  1. Select JSON, and then Create.

bq_connector_for_jira_dc_custome_role_service_account_16.gif

  • The private key will be automatically saved to your computer.

bq_connector_for_jira_dc_custome_role_service_account_note1.gif

  • To use BigQuery, you have to enable billing on the corresponding project. From the home page, select Billing, and then follow the instructions provided on the screen.

Billing.jpg