/
How to Export Data into BigQuery

How to Export Data into BigQuery

Owned by Liliia Ostrovska
Last updated: Mar 13, 2025
2 min read

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 status: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.

 

  1. Select Export data.

bq_connector_for_jira_tempo_-_export_3.gif

The data source status will be changed to status: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.

 

  1. Find your exported data source by the dataset name you used while creating the data source.

In our case, it’s Jiras_dataset_13.

 

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.

 

Related content