Below you can find a description of the fields, buttons, and settings of the data source creating page.
General Settings
Name* - This field allows you to enter the name of your data source. The field is required.
Dataset name* - This field allows you to enter the name of a dataset for exporting data to BigQuery. Dataset is a resource where your Jira data will be located. The field is required.
Description - This field allows you to enter a description for your data source. These might be some hints you might need in the future. This field is optional.
Share Settings
These settings allow you to share your data source with users or groups who have permission to use BigQuery Connector.
Users - This setting allows you to share your data source with other users. You can select as many individual users as you need to. The user can be searched by login or full email.
Groups - This setting allows you to share your data source with groups. You can select as many groups as you want to.
Other users who have access to BigQuery Connector for Jira app might not get all data from this data source due to different Jira permissions.
Search and View Settings
Search Section
The Search box - This box allows you to quickly find, and then add to your export issue filters you need.
The amount of found issue filters will be shown on each tab you have.
Configure View
Configure view - This setting allows you to adjust the appearance of the issues. You can select what option to display: Show IDs or Show types. The Show names option is a default. All options can be selected at once.
The screenshot presents how the options are displayed in the UI, using matching colors.
Select Tables Section
These settings allow you to select or cancel selecting Jira standard tables and fields (Jira Work Management, Jira Software, Jira Service Management) and also tables and fields of different plug-ins installed on your Jira Cloud instance (e.g. Xray, Projectrak, Tempo, and more).
Save and Preview Section
After creating and editing your data source, you can select one of the following options what to do with it.
Save - This option creates your new data source or updates if you edit an existing data source.
Preview -This option allows you to check the source name, source description, issue filters, and export items.
Preview ERD - This option allows you to view the Entity Relationship Diagram for your Connector support data source, which is generated based on the checkboxes you have selected before.
This screenshot displays how the Preview button works. Once you select it, the pop-up window will appear with the view of your data source, so you can check if all changes are correct.
This screenshot displays how the Preview ERD button works. Once you select it, the pop-up window will appear with the view of an Entity Relationship Diagram for tables and fields selected in the data source.
Additional Features
All these settings are applied to already existing data sources.
Export data - This button exports the data source to BigQuery.
The Actions (three dots) panel introduces you to different actions:
Auto-export - This function allows you to configure auto-export (auto-refresh) of the data source.
Edit - This function allows you to make changes to the data source.
Delete - This function allows you to remove the data source.
Share - This function allows you to distribute the data source to users who have permission to use this app.
Archive - This function allows you to mark the data source as archived, data source will be moved to the Archived tab.
Clone - This function allows you to make a copy of the data source.
Preview ERD - This function allows you to view the Entity Relationship Diagram for a data source.
Set BQ Key - This function allows you to connect your service account key to your Jira data source for further exporting.
How to Change the Owner of the Data Source
BigQuery Connector for Jira allows you to change the initial owner of the data sources. In this case, the person who created the data source will no longer see this data source in their My data sources list, the data source will appear in another user's list. The new owner can see, edit, delete, and share the data source.
The new owner needs to submit their account key to the shared data source.
In your Jira Cloud instance, select Apps, and then select BigQuery Connector for Jira.
On the left-side menu, select Data Source.
In the Owner column, select the Expand icon, and then select the name of the user you need.
If you can’t find the required name, start typing the name you need, and the list of suggestions will appear.
After you select the name, the Change owner pop-up window will appear.
Select Save.
Have experience with BigQuery Connector for Jira? We’d love to hear your thoughts! Please leave us a review on the Marketplace! 😊