How to Create Service Account Key

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


  1. Open your project in the Google Cloud Platform.

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


  1. Select APIs & Services.


  1. Select Credentials.


  1. Select +CREATE CREDENTIALS, and then select Service account.


  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. In the Service account description, enter the description for your service account.



  1. In the Select a role field, select Owner.


  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.



  1. Select Manage service accounts.


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


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


  1. Select JSON, and then CREATE.