Data Source Page Overview

Below you can find a description of the fields, buttons, and settings of the data source creating page.

 

Title Settings and More

 

  • 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 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.

  • Service account key* and Choose File - This field allows you to select the file of your service account key. This key is used for authentication in BigQuery. The field is required.

bq_create_ds_title.jpg

 

  • Users - This setting allows you to share your data source with individual users.

  • Groups - This setting allows you to share your data source with groups you have within your instance.

  • Project Roles - This setting allows you to share your data source with users who have the appropriate project roles.

  • Allow re-sharing this data source - This setting allows users to share data source that was shared with them.

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.

 

bq_create_ds_share.jpg

 

Auto-Export Section

 

  • Enable Auto-Export - This feature allows you to enable or disable auto-refresh of your data source. Once it’s enabled, your data source will be automatically exported to the pre-defined dataset.

You can select different frequencies of auto-export.

 

  • Export interval - This option allows you to select frequency, ranging from Every 15 minutes to Daily basis.

 

  • Daily at specific time - This option allows you to select a specific time of the auto-export.

 

  • Cron - This option allows you to enter cron expression if you need to.

To learn more about cron expression, please visit support Atlassian and Cron Expression Generator & Explainer.

 

Search and View Settings

 

Search Field

 

  • Search field - This search box simplifies the search for the required field you want to be displayed in the report.

View Options

 

  • View options - 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.

    • Show IDs - This is how your fields will appear in BigQuery.

 

Select Issues Section

 

  • This section allows you to select or cancel selecting issues (tables) for exporting. This section displays standard Jira fields and all installed and configured plug-ins.

    • Jira Work Management - This part of the section displays a list of regular Jia Core fields and items.

    • Jira Software - This part of the section displays a list of regular Jira Software fields and items if Jira Software is licensed.

    • Service Service Management - This part of the section displays a list of regular Jira Service Desk fields and items if Service Management is licensed.

 

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

 

Additional Feature

 

All these settings are applied to already existing data sources.

 

  • Export data - This button exports the data source to BigQuery dataset.

 

The Actions (three dots) panel introduces you to different actions:

  • Edit - This function allows you to make changes to the data source.

  • Clone - This function allows you to make a copy of the data source.

  • Archive - This function allows you to mark the data source as archived, data source will be moved to the Archived tab.

  • Preview ERD - This function allows you to view the Entity Relationship Diagram for a data source.

  • Auto Export - This function allows you to configure auto-export (auto-refresh) of the data source.

  • Export History - This function allows you to view exports history entities.

  • Delete - This function allows you to remove the data source.

  • Share Settings - This function allows you to distribute the data source to users who have permission to use this app.