| Info |
|---|
Before you start, your Jira administrator should grant you Administer Jira permissions to create, edit, watch, and export connectors. Users with Administer Jira permissions always have access to BigQuery Connector for Jira. |
How to Export Data from Jira to BigQuery
📘 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.
.gif?version=1&modificationDate=1709721206870&cacheVersion=1&api=v2&width=98)
Data Schema
| Panel | ||
|---|---|---|
| ||
📘 Create Data Source
A data source is the primary source of data sets containing tables and fields for further analysis. It represents the data selected by the user for export to BigQuery.
| Panel | ||
|---|---|---|
| ||
📘 Export Data from Jira to BigQuery
Exporting data from Jira to BigQuery involves connecting to BigQuery using a previously created service account key and transferring the datasets included in the data source.
| Panel | ||
|---|---|---|
| ||
📘 Data Schema
Since the BigQuery Connector for Jira does not automatically create relationships between tables and fields in BigQuery, we provide info on how to build them correctly in Entity Relationship Diagram.
| Panel | ||
|---|---|---|
| ||
Learn more about BigQuery data load methods ⬇️
https://www.alphaservesp.com/blog/load-data-into-bigquery-most-common-ways-overview/#methods
