Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Infopanel
panelIconIdatlassian-light_bulb_on
panelIcon:light_bulb_on:
panelIconText:light_bulb_on:
bgColor#DEEBFF

How to Optimize Data Export Time.

  1. Being signed in to your Jira Cloud instance, select Apps, and then select BigQuery Connector for Jira.

  1. Select Create data source.

Image Removedbq-create-data-source-1.gifImage Added

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

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

  3. [Optional] In the Description field, enter the description for your data source.

Info

To read about Dataset location settings.

bq-create-data-source-general-settings.gifImage Added

  1. Select Sharing settings.

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

with. InfoOnce you start typing, the drop-down list
  1. with

usernames suggestions will appear. Select the user from the list
  1. .

You can select as many individual users as you need to.

  1. [Optional] In the

Group
  1. Groups field, select the group you need.

Info

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

You can select as many individual users and groups as you need to.

Image Removedbq-create-data-source-sharing-settings.gifImage Added

  1. Select all

filters and
  1. tables you want to be in your data source.

Info

Now for your convenience ,

and then select Save.

you can adjust table visibility, table sorting, and field details by selecting View settings. Click here to read more.

select-tables-and-fields.gifImage Added
Panel
panelIconId1f4d8
panelIcon:blue_book:
panelIconText📘
bgColor#DEEBFF

To view and export data from 3rd-party pluginsapps such as Projectrak, Zephyr Squad, Time in Status, and others, you must first install these plugins apps on your Jira instance. After installation, add the relevant token to proceed with data access and export.

For more information, check the Supported Add-OnsApps section.

Select fields.gifImage Removed

You can select
  1. Select filters you need, and then select Save.

Info

There are different filters group:

  • No filters (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.

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

Select filters.gifImage Modified

Panel
panelIconId1f50e
panelIcon:mag_right:
panelIconText🔎
bgColor#C0B6F2

What’s the next step? Export data into BigQuery to start building insightful reports.