BigQuery Connector for Jira (Cloud)
Breadcrumbs

Importing Jira Data into BigQuery

⚙️

Without a Jira API token, the export may be limited to 10,000 users, and inactive users will not be included.

The newly-created data source has the NOT EXPORTED status.

bq_connector_for_jira_tempo_-_export_NOT_EXPORTED.gif
  1. Select three dots, and then select Set BQ Key.

How to create a service account key.

BQ key is another name for the service account key.

bq_connector_for_jira_tempo_-_export_1.gif
  1. Select Choose file, upload your service account key, and then select Save.

Choose file and save (1).gif
  1. Select Export data.

bq_connector_for_jira_tempo_-_export_3.gif

The data source status will be changed to LOADING .

bq_connector_for_jira_tempo_-_export_LOADING.gif

After the export is finished, the data source status will be set to EXPORTED.

bq_connector_for_jira_tempo_-_export_EXPORTED.gif
  1. Open your Google Cloud Platform, and then select BigQuery.

Please ensure that the correct project is selected. It’s supposed to be the one where you’ve created the service account key.

Google Cloud Console - BigQuery.gif
  1. Find your exported data source by the dataset name you used while creating the data source.

Result.gif

If the export process takes too long, you can cancel it by selecting Cancel export. Any data exported before cancellation will remain in the dataset.

The cancellation process may take up to a minute.

bq_connector_for_jira_tempo_-_export_cancel_export.gif
🔎

What’s the next step? Explore the Supported Apps section to discover additional possibilities to enrich your report.