1. Being signed in to your Jira instance, select BigQuery, and then select Data Sources.

  1. Select Create Data Source.

Create data source1.gif

  1. In the Name* field, enter your data source name.

The Description field is optional. You can enter data related to your data source or some hints you might need in the future.

  1. In the Dataset name* field, enter the dataset name for exporting data.

  2. In the Service account key* field, select Choose File, and then select your service account key.

bq_create_ds_title.jpg

  1. [Optional] In the Users field, enter the username you want to share the data source with.

Once you start typing, the drop-down list with username suggestions will appear. Select the user from the list.

  1. [Optional] In the Groups field, select the group you need.

Once you select the Groups field, the drop-down list with available groups will appear. Select a group from the list.

  1. [Optional] In the Project Roles field, select the roles you need.

Once you select the Project Roles field, the drop-down list with available project roles will appear. Select a role from the list.

Other users who have access to BigQuery Connector might not get all the data from this data source due to different Jira permissions.

bq_create_ds_share.jpg

note

You can also allow other users who have permissions to use BigQuery Connector to re-share the data source.

You can also allow other users who have permissions to use BigQuery Connector to re-share the data source.

bq_create_ds_resharing.jpg

If needed, enable auto-export to have your data source exported at the set time interval.

bq_create_ds_auto_export.jpg

  1. Select all filters and tables you want to be in your data source, and then select Save.

note

You can select different filter groups:

  • All (by default) - will return all data, select it, if you want to export all existing issues.

  • JQL - Jira Query Language, is a flexible tool that allows you to search for issues, projects, etc. in Jira and pinpoint exactly what you are looking for. Select it, if you want to use JQL to create your own request and filter data.

  • Basic - select it, if you want to use standard fields filters.

You can select different filter groups:

  • All (by default) - will return all data, select it, if you want to export all existing issues.

  • JQL - Jira Query Language, is a flexible tool that allows you to search for issues, projects, etc. in Jira and pinpoint exactly what you are looking for. Select it, if you want to use JQL to create your own request and filter data.

  • Basic - select it, if you want to use standard fields filters.

A detailed description of all fields, filters, and buttons, please read in this article. If you need additional information about Jira filters, please refer to this section.

bq_create_ds_filters.jpgbq_create_ds_tables.jpg