Skip to content
Book a demoStart free
Connectors

Jira connector

Set up the Jira connector in Kaivo: authentication, configuration, the 56 BigQuery tables it syncs, and answers to common questions.

Jira connector pricing, tier and credits on kaivo.io

Kaivo is a fully managed data platform that syncs your Jira data into a Google BigQuery warehouse and keeps it up to date automatically. There is no pipeline to build and no infrastructure to run, so you can spend your time analysing your project management data instead of moving it.

Sync your Jira issues, boards, sprints, and worklogs into BigQuery with Kaivo to report on delivery and project progress without exporting spreadsheets.

CategoryProject Management
AuthenticationAPI key
SetupSelf-service
  1. Sign up for Kaivo and create a workspace.
  2. Connect your Jira account.
  3. Choose which tables to sync.
  4. Wait for the initial sync to finish.
  5. Query your data in BigQuery or your favourite AI or BI tool.

Authenticate with your API Token.

Field Description
API Token
Jira API Token. Generate your token here.

|

When you set up the connector, you provide:

Field Description
Domain
The Domain for your Jira account, e.g. “your-domain.atlassian.net”, “your-domain.jira.com”, “jira.your-domain.com”

| | Email |

The user email for your Jira account which you used to generate the API token.

| | Projects |

List of Jira project keys to replicate data for, or leave it empty if you want to replicate data for all projects. The project key is shown in the URL on the Jira website (e.g. “projects/PROJECT_KEY”).

| | Start Date |

Any data before this date will not be fetched.

|

Kaivo syncs 56 tables from Jira into a dedicated dataset in your BigQuery warehouse. Click any table to see its columns and types.

application_roles (12 columns), Details of an application role.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING The key identifier of the application role.
name STRING The display name of the application role.
selected_by_default BOOL Determines if this application role should be selected by default on user creation.
defined BOOL Deprecated.
number_of_seats INT64 The maximum count of users allowed on the license.
remaining_seats INT64 The count of remaining user seats on the license.
user_count INT64 The total count of users that are counted against the license limit.
user_count_description STRING Describes the type of users being counted against your license. For more information, refer to the provided link.
has_unlimited_seats BOOL Indicates if the application role has unlimited user seats.
… and 2 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • application_roles__groups (4 columns)
  • application_roles__default_groups (4 columns)
  • application_roles__group_details (3 columns)
  • application_roles__default_groups_details (6 columns)
avatars (8 columns), List of system avatars.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the avatar.
owner STRING The owner of the avatar. For a system avatar, the owner is null (and nothing is returned). For non-system avatars, this is the appropriate identifier, such as the ID for a project or the account ID for a user.
is_system_avatar BOOL Whether the avatar is a system avatar.
is_selected BOOL Whether the avatar is used in Jira. For example, shown as a project’s avatar.
is_deletable BOOL Whether the avatar can be deleted.
file_name STRING The file name of the avatar icon. Returned for system avatars.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
board_issues (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING A parameter indicating the details to be included in the response
id STRING The unique identifier of the issue
self STRING URL of the issue
key STRING The unique key of the issue
fields__flagged BOOL Indicator if the issue is flagged for attention
fields__description STRING Description of the issue
fields__created TIMESTAMP The date and time when the issue was created
fields__updated TIMESTAMP The date and time when the issue was last updated
board_id INT64 The unique identifier of the board where the issue belongs
… and 3 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • board_issues__fields__comment (3 columns)
  • board_issues__fields__worklog (3 columns)
boards (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 Unique identifier of the board.
self STRING URI that points to the board data.
name STRING Name of the board.
type STRING Type of the board.
project_id STRING ID of the project to which the board belongs.
project_key STRING Key of the project to which the board belongs.
location__project_id INT64 ID of the project to which the board location belongs.
location__user_id INT64 ID of the user associated with the board location.
location__user_account_id STRING Account ID of the user associated with the board location.
… and 7 more columns
dashboards (22 columns), Details of a dashboard.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
description STRING The description of the dashboard.
id STRING The ID of the dashboard.
is_favourite BOOL Indicates whether the dashboard is marked as a favorite by the user.
name STRING The name of the dashboard.
owner__key STRING Deprecated. Use `accountId` for privacy reasons.
owner__self STRING The URL of the dashboard owner details.
owner__name STRING Deprecated. Use `accountId` for privacy reasons.
owner__display_name STRING The display name of the dashboard owner. Privacy settings may affect the display value.
owner__active BOOL Indicates whether the owner is an active user.
… and 12 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • dashboards__share_permissions (119 columns)
  • dashboards__share_permissions__project__lead__groups__items (5 columns)
  • dashboards__share_permissions__project__lead__application_roles__items (13 columns)
  • dashboards__share_permissions__project__lead__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__lead__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__project__components (71 columns)
  • dashboards__share_permissions__project__components__lead__groups__items (5 columns)
  • dashboards__share_permissions__project__components__lead__application_roles__items (13 columns)
  • dashboards__share_permissions__project__components__lead__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__components__lead__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__project__components__assignee__groups__items (5 columns)
  • dashboards__share_permissions__project__components__assignee__application_roles__items (13 columns)
  • dashboards__share_permissions__project__components__assignee__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__components__assignee__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__project__components__real_assignee__groups__items (5 columns)
  • dashboards__share_permissions__project__components__real_assignee__application_roles__items (13 columns)
  • dashboards__share_permissions__project__components__real_assignee__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__components__real_assignee__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__project__issue_types (27 columns)
  • dashboards__share_permissions__project__versions (22 columns)
  • dashboards__share_permissions__project__versions__operations (10 columns)
  • dashboards__share_permissions__project__issue_type_hierarchy__level (11 columns)
  • dashboards__share_permissions__project__issue_type_hierarchy__level__issue_type_ids (4 columns)
  • dashboards__share_permissions__project__deleted_by__groups__items (5 columns)
  • dashboards__share_permissions__project__deleted_by__application_roles__items (13 columns)
  • dashboards__share_permissions__project__deleted_by__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__deleted_by__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__project__archived_by__groups__items (5 columns)
  • dashboards__share_permissions__project__archived_by__application_roles__items (13 columns)
  • dashboards__share_permissions__project__archived_by__application_roles__items__groups (4 columns)
  • dashboards__share_permissions__project__archived_by__application_roles__items__default_groups (4 columns)
  • dashboards__share_permissions__role__actors (11 columns)
  • dashboards__editpermission (5 columns)
  • dashboards__edit_permissions (3 columns)
filter_sharing (120 columns), Details of a share permission for the filter.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier of the share permission.
filter_id STRING Id of the related filter
type STRING The type of share permission: * `group` Shared with a group. If set in a request, then specify `sharePermission.group` as well. * `project` Shared with a project. If set in a request, then specify `sharePermission.project` as well. * `projectRole` Share with a project role in a project. This value is not returned in responses. It is used in requests, where it needs to be specify with `projectId` and `projectRoleId`. * `global` Shared globally. If set in a request, no other `sharePermission` properties need to be specified. * `loggedin` Shared with all logged-in users. Note: This value is set in a request by specifying `authenticated` as the `type`. * `project-unknown` Shared with a project that the user does not have access to. Cannot be set in a request.
project__expand STRING Expand options that include additional project details in the response.
project__self STRING The URL of the project details.
project__id STRING The ID of the project.
project__key STRING The key of the project.
project__description STRING A brief description of the project.
project__lead__self STRING The URL of the user.
… and 110 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • filter_sharing__project__lead__groups__items (5 columns)
  • filter_sharing__project__lead__application_roles__items (13 columns)
  • filter_sharing__project__lead__application_roles__items__groups (4 columns)
  • filter_sharing__project__lead__application_roles__items__default_groups (4 columns)
  • filter_sharing__project__components (71 columns)
  • filter_sharing__project__components__lead__groups__items (5 columns)
  • filter_sharing__project__components__lead__application_roles__items (13 columns)
  • filter_sharing__project__components__lead__application_roles__items__groups (4 columns)
  • filter_sharing__project__components__lead__application_roles__items__default_groups (4 columns)
  • filter_sharing__project__components__assignee__groups__items (5 columns)
  • filter_sharing__project__components__assignee__application_roles__items (13 columns)
  • filter_sharing__project__components__assignee__application_roles__items__groups (4 columns)
  • filter_sharing__project__components__assignee__application_roles__items__default_groups (4 columns)
  • filter_sharing__project__components__real_assignee__groups__items (5 columns)
  • filter_sharing__project__components__real_assignee__application_roles__items (13 columns)
  • filter_sharing__project__components__real_assignee__application_roles__items__groups (4 columns)
  • filter_sharing__project__components__real_assignee__application_roles__items__default_groups (4 columns)
  • filter_sharing__project__issue_types (27 columns)
  • filter_sharing__project__versions (22 columns)
  • filter_sharing__project__versions__operations (10 columns)
  • filter_sharing__project__issue_type_hierarchy__level (11 columns)
  • filter_sharing__project__issue_type_hierarchy__level__issue_type_ids (4 columns)
  • filter_sharing__project__deleted_by__groups__items (5 columns)
  • filter_sharing__project__deleted_by__application_roles__items (13 columns)
  • filter_sharing__project__deleted_by__application_roles__items__groups (4 columns)
  • filter_sharing__project__deleted_by__application_roles__items__default_groups (4 columns)
  • filter_sharing__project__archived_by__groups__items (5 columns)
  • filter_sharing__project__archived_by__application_roles__items (13 columns)
  • filter_sharing__project__archived_by__application_roles__items__groups (4 columns)
  • filter_sharing__project__archived_by__application_roles__items__default_groups (4 columns)
  • filter_sharing__role__actors (11 columns)
filters (33 columns), Details of a filter.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Expands the additional information about the filter
self STRING The URL of the filter.
id STRING The unique identifier for the filter.
name STRING The name of the filter. Must be unique.
description STRING A description of the filter.
owner__self STRING The URL of the user.
owner__key STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
owner__account_id STRING The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, *5b10ac8d82e05b22cc7d4ef5*. Required in requests.
owner__account_type STRING The user account type. Can take the following values: * `atlassian` regular Atlassian user account * `app` system account used for Connect applications and OAuth to represent external systems * `customer` Jira Service Desk account representing an external service desk
… and 23 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • filters__owner__groups__items (5 columns)
  • filters__owner__application_roles__items (13 columns)
  • filters__owner__application_roles__items__groups (4 columns)
  • filters__owner__application_roles__items__default_groups (4 columns)
  • filters__share_permissions (120 columns)
  • filters__share_permissions__project__lead__groups__items (5 columns)
  • filters__share_permissions__project__lead__application_roles__items (13 columns)
  • filters__share_permissions__project__lead__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__lead__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__project__components (71 columns)
  • filters__share_permissions__project__components__lead__groups__items (5 columns)
  • filters__share_permissions__project__components__lead__application_roles__items (13 columns)
  • filters__share_permissions__project__components__lead__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__components__lead__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__project__components__assignee__groups__items (5 columns)
  • filters__share_permissions__project__components__assignee__application_roles__items (13 columns)
  • filters__share_permissions__project__components__assignee__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__components__assignee__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__project__components__real_assignee__groups__items (5 columns)
  • filters__share_permissions__project__components__real_assignee__application_roles__items (13 columns)
  • filters__share_permissions__project__components__real_assignee__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__components__real_assignee__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__project__issue_types (27 columns)
  • filters__share_permissions__project__versions (22 columns)
  • filters__share_permissions__project__versions__operations (10 columns)
  • filters__share_permissions__project__issue_type_hierarchy__level (11 columns)
  • filters__share_permissions__project__issue_type_hierarchy__level__issue_type_ids (4 columns)
  • filters__share_permissions__project__deleted_by__groups__items (5 columns)
  • filters__share_permissions__project__deleted_by__application_roles__items (13 columns)
  • filters__share_permissions__project__deleted_by__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__deleted_by__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__project__archived_by__groups__items (5 columns)
  • filters__share_permissions__project__archived_by__application_roles__items (13 columns)
  • filters__share_permissions__project__archived_by__application_roles__items__groups (4 columns)
  • filters__share_permissions__project__archived_by__application_roles__items__default_groups (4 columns)
  • filters__share_permissions__role__actors (11 columns)
  • filters__subscriptions (25 columns)
  • filters__subscriptions__user__groups__items (5 columns)
  • filters__subscriptions__user__application_roles__items (13 columns)
  • filters__subscriptions__user__application_roles__items__groups (4 columns)
  • filters__subscriptions__user__application_roles__items__default_groups (4 columns)
groups (4 columns), The list of groups found in a search, including header text (Showing X of Y matching groups) and total of matched groups.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
name STRING The name of the group.
group_id STRING The ID of the group, if available, which uniquely identifies the group across all Atlassian products. For example, *952d12c3-5b5b-4d04-bb32-44d383afc4b2*.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_changelogs (17 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the changelog.
author__self STRING The URL of the user.
author__active BOOL Whether the user is active.
author__time_zone STRING The time zone specified in the user’s profile. Depending on the user’s privacy settings, this may be returned as null.
author__account_id STRING The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, 5b10ac8d82e05b22cc7d4ef5.
author__avatar_urls___16x16 STRING The URL of the item’s 16x16 pixel avatar.
author__avatar_urls___24x24 STRING The URL of the item’s 24x24 pixel avatar.
author__avatar_urls___32x32 STRING The URL of the item’s 32x32 pixel avatar.
author__avatar_urls___48x48 STRING The URL of the item’s 48x48 pixel avatar.
… and 7 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_changelogs__items (10 columns)
issue_comments (12 columns), A comment.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the comment.
id STRING The ID of the comment.
issue_id STRING Id of the related issue.
author JSON The ID of the user who created the comment.
rendered_body STRING The rendered version of the comment.
created TIMESTAMP The date and time at which the comment was created.
updated TIMESTAMP The date and time at which the comment was updated last.
visibility__type STRING Whether visibility of this item is restricted to a group or role.
visibility__value STRING The name of the group or role to which visibility of this item is restricted.
… and 2 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_comments__properties (4 columns)
issue_custom_field_contexts (9 columns), The details of a custom field context.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the context.
field_id STRING Id of the related field
name STRING The name of the context.
description STRING The description of the context.
is_global_context BOOL Whether the context is global.
is_any_issue_type BOOL Whether the context applies to all issue types.
field_type STRING The type of the related field
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_custom_field_options (8 columns), Details of the custom field options for a context.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the custom field option.
value STRING The value of the custom field option.
option_id STRING For cascading options, the ID of the custom field option containing the cascading option.
disabled BOOL Whether the option is disabled.
field_id STRING The ID of the custom field to which the option belongs.
context_id STRING The ID of the context to which the custom field option belongs.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_field_configurations (6 columns), Details of a field configuration.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the field configuration.
name STRING The name of the field configuration.
description STRING The description of the field configuration.
is_default BOOL Whether the field configuration is the default.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_fields (30 columns), Details about a field.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the field.
key STRING The key of the field.
name STRING The name of the field.
custom BOOL Whether the field is a custom field.
orderable BOOL Whether the content of the field can be used to order lists.
navigable BOOL Whether the field can be used as a column on the issue navigator.
searchable BOOL Whether the content of the field can be searched.
scope__type STRING The type of scope.
scope__project__self STRING The URL of the project details.
… and 20 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_fields__clause_names (4 columns)
issue_link_types (7 columns), A list of issue link type beans.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the issue link type. Used as the type of issue link in `issueLink` resource. Required on create when `name` isn’t provided. Otherwise, read only.
name STRING The name of the issue link type. Used as the type of issue link in `issueLink` resource. Required on create when `id` isn’t provided. Otherwise, read only.
inward STRING The description of the issue link type inward link. Read only in `issueLink` resource. Required on create and optional on update in `issueLinkType` resource. Otherwise, read only.
outward STRING The description of the issue link type outward link. Read only in `issueLink` resource. Required on create and optional on update in `issueLinkType` resource. Otherwise, read only.
self STRING The URL of the issue link type. Read only.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_navigator_settings (4 columns), Details of an issue navigator column item.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
label STRING The label representing the data displayed in the issue navigator column.
value STRING The actual value/data associated with the label in the issue navigator column.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_notification_schemes (22 columns), Details about a notification scheme.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Expand options that include additional notification scheme details in the response.
id INT64 The ID of the notification scheme.
self STRING
name STRING The name of the notification scheme.
description STRING The description of the notification scheme.
scope__type STRING The type of scope.
scope__project__self STRING The URL of the project details.
scope__project__id STRING The ID of the project.
scope__project__key STRING The key of the project.
… and 12 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_notification_schemes__notification_scheme_events (6 columns)
  • issue_notification_schemes__notification_scheme_events__notifications (74 columns)
  • issue_notification_schemes__notification_scheme_events__notifications__field__clause_names (4 columns)
  • issue_notification_schemes__notification_scheme_events__notifications__project_role__actors (11 columns)
issue_priorities (9 columns), An issue priority.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the issue priority.
status_color STRING The color used to indicate the issue priority.
description STRING The description of the issue priority.
icon_url STRING The URL of the icon for the issue priority.
name STRING The name of the issue priority.
id STRING The ID of the issue priority.
is_default BOOL Indicates if this issue priority is the default.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_properties (6 columns), An entity property, for more information see [Entity properties](https://developer.atlassian.com/cloud/jira/platform/jira-entity-properties/).
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING The key of the property. Required on create and update.
issue_id STRING Id of the related issue.
value JSON The value of the property. Required on create and update.
isdefault BOOL Indicates if the property is the default property.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_remote_links (19 columns), Details of an issue remote link.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the link.
issue_id STRING Id of the related issue.
self STRING The URL of the link.
global_id STRING The global ID of the link, such as the ID of the item on the remote system.
application__type STRING The name-spaced type of the application, used by registered rendering apps.
application__name STRING The name of the application. Used in conjunction with the (remote) object icon title to display a tooltip for the link’s icon. The tooltip takes the format “[application name] icon title”. Blank items are excluded from the tooltip title. If both items are blank, the icon tooltop displays as “Web Link”. Grouping and sorting of links may place links without an application name last.
relationship STRING Description of the relationship between the issue and the linked item.
object__url STRING The URL of the item.
object__title STRING The title of the item.
… and 9 more columns
issue_resolutions (7 columns), Details of an issue resolution.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the issue resolution.
id STRING The ID of the issue resolution.
description STRING The description of the issue resolution.
name STRING The name of the issue resolution.
is_default BOOL Indicates if this is the default issue resolution.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_security_schemes (7 columns), List of security schemes.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the issue security scheme.
id INT64 The ID of the issue security scheme.
name STRING The name of the issue security scheme.
description STRING The description of the issue security scheme.
default_security_level_id INT64 The ID of the default security level.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_security_schemes__levels (7 columns)
issue_transitions (22 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
fields STRING Represents the custom fields associated with the issue transition
has_screen BOOL Indicates if the transition has an associated screen
id STRING Unique identifier for the issue transition
issue_id STRING Identifier of the issue associated with the transition
is_available BOOL Indicates if the transition is available
is_conditional BOOL Indicates if the transition is conditional
is_global BOOL Indicates if the transition is global
is_initial BOOL Indicates if the transition is the initial transition
is_looped BOOL Indicates if the transition is a loop transition
… and 12 more columns
issue_type_schemes (7 columns), Details of an issue type scheme.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique identifier for the issue type scheme.
name STRING The name given to the issue type scheme.
description STRING A brief description of the issue type scheme.
default_issue_type_id STRING The ID of the default issue type associated with the issue type scheme.
is_default BOOL Indicates whether the issue type scheme is set as the default.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_type_screen_schemes (5 columns), Details of an issue type screen scheme.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the issue type screen scheme.
name STRING The name of the issue type screen scheme.
description STRING The description of the issue type screen scheme.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
issue_types (27 columns), Details about an issue type.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
avatar_id INT64 The ID of the issue type’s avatar.
description STRING The description of the issue type.
entity_id STRING Unique ID for next-gen projects.
hierarchy_level INT64 Hierarchy level of the issue type.
icon_url STRING The URL of the issue type’s avatar.
id STRING The ID of the issue type.
name STRING The name of the issue type.
self STRING The URL of these issue type details.
subtask BOOL The URL of these issue type details.
… and 17 more columns
issue_votes (6 columns), The details of votes on an issue.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of these issue vote details.
issue_id STRING Id of the related issue.
votes INT64 The number of votes on the issue.
has_voted BOOL Whether the user making this request has voted on the issue.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_votes__voters (22 columns)
  • issue_votes__voters__groups__items (5 columns)
  • issue_votes__voters__application_roles__items (13 columns)
  • issue_votes__voters__application_roles__items__groups (4 columns)
  • issue_votes__voters__application_roles__items__default_groups (4 columns)
issue_watchers (6 columns), The details of watchers on an issue.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of these issue watcher details.
issue_id STRING Id of the related issue.
is_watching BOOL Whether the calling user is watching this issue.
watch_count INT64 The number of users watching this issue.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_watchers__watchers (16 columns)
issue_worklogs (38 columns), Details of a worklog.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the worklog item.
author__self STRING The URL of the user.
author__name STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
author__key STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
author__account_id STRING The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, *5b10ac8d82e05b22cc7d4ef5*.
author__email_address STRING The email address of the user. Depending on the user’s privacy settings, this may be returned as null.
author__avatar_urls___16x16 STRING The URL of the item’s 16x16 pixel avatar.
author__avatar_urls___24x24 STRING The URL of the item’s 24x24 pixel avatar.
author__avatar_urls___32x32 STRING The URL of the item’s 32x32 pixel avatar.
… and 28 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issue_worklogs__properties (5 columns)
issues (167 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Expand options that include additional issue details in the response.
id STRING The unique ID of the issue.
self STRING The URL of the issue details.
key STRING The unique key of the issue.
rendered_fields__statuscategorychangedate STRING
rendered_fields__issuetype STRING
rendered_fields__timespent STRING
rendered_fields__project STRING
rendered_fields__fix_versions STRING
… and 157 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • issues__rendered_fields__labels (4 columns)
  • issues__rendered_fields__issuelinks (4 columns)
  • issues__rendered_fields__components (3 columns)
  • issues__rendered_fields__attachment (4 columns)
  • issues__rendered_fields__subtasks (4 columns)
  • issues__rendered_fields__comment__comments (32 columns)
  • issues__rendered_fields__comment__comments__body__content (4 columns)
  • issues__rendered_fields__comment__comments__body__content__content (5 columns)
  • issues__rendered_fields__worklog__worklogs (4 columns)
  • issues__transitions (21 columns)
  • issues__changelog__histories (16 columns)
  • issues__changelog__histories__items (12 columns)
  • issues__fields__attachment (4 columns)
  • issues__fields__comment__comments (4 columns)
  • issues__fields__components (4 columns)
  • issues__fields__description__content (4 columns)
  • issues__fields__description__content__content (5 columns)
  • issues__fields__fix_versions (4 columns)
  • issues__fields__issuelinks (4 columns)
  • issues__fields__labels (4 columns)
  • issues__fields__subtasks (4 columns)
  • issues__fields__versions (4 columns)
  • issues__fields__worklog__worklogs (35 columns)
  • issues__fields__worklog__worklogs__comment__content (4 columns)
  • issues__fields__worklog__worklogs__comment__content__content (5 columns)
jira_settings (10 columns), Details of an application property.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The unique ID of the application property. The ID is the same as the key.
key STRING The key identifier of the application property. The key is the same as the ID.
value STRING The new value assigned to the application property.
name STRING The name or title of the application property.
desc STRING The description of the application property.
type STRING The data type (e.g., string, number) of the application property.
default_value STRING The default value of the application property.
example STRING An example or sample value for the application property.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • jira_settings__allowed_values (4 columns)
labels (3 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
label STRING The label associated with the issue in Jira.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
permission_schemes (22 columns), List of all permission schemes.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING The expand options available for the permission scheme.
id INT64 The ID of the permission scheme.
self STRING The URL of the permission scheme.
name STRING The name of the permission scheme. Must be unique.
description STRING A description for the permission scheme.
scope__type STRING The type of scope.
scope__project__self STRING The URL of the project details.
scope__project__id STRING The ID of the project.
scope__project__key STRING The key of the project.
… and 12 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • permission_schemes__permissions (10 columns)
permissions (6 columns), Details about permissions.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING Unique key identifier for the permission
name STRING Name of the permission
type STRING Type of permission
description STRING Description of the permission
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_avatars (9 columns), List of project avatars.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the avatar.
project_id STRING Id of the related project.
owner STRING The owner of the avatar. For a system avatar the owner is null (and nothing is returned). For non-system avatars this is the appropriate identifier, such as the ID for a project or the account ID for a user.
is_system_avatar BOOL Whether the avatar is a system avatar.
is_selected BOOL Whether the avatar is used in Jira. For example, shown as a project’s avatar.
is_deletable BOOL Whether the avatar can be deleted.
file_name STRING The file name of the avatar icon. Returned for system avatars.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_categories (6 columns), A project category.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the project category.
id STRING The ID of the project category.
name STRING The name of the project category. Required on create, optional on update.
description STRING The description of the project category. Required on create, optional on update.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_components (52 columns), Details about a project component.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the component.
id STRING The unique identifier for the component.
name STRING The unique name for the component in the project. Required when creating a component. Optional when updating a component. The maximum length is 255 characters.
description STRING The description for the component. Optional when creating or updating a component.
lead__self STRING The URL of the user.
lead__key STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
lead__account_id STRING The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, *5b10ac8d82e05b22cc7d4ef5*. Required in requests.
lead__account_type STRING The user account type. Can take the following values: * `atlassian` regular Atlassian user account * `app` system account used for Connect applications and OAuth to represent external systems * `customer` Jira Service Desk account representing an external service desk
lead__name STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
… and 42 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • project_components__lead__groups__items (5 columns)
  • project_components__lead__application_roles__items (13 columns)
  • project_components__lead__application_roles__items__groups (4 columns)
  • project_components__lead__application_roles__items__default_groups (4 columns)
  • project_components__assignee__groups__items (5 columns)
  • project_components__assignee__application_roles__items (13 columns)
  • project_components__assignee__application_roles__items__groups (4 columns)
  • project_components__assignee__application_roles__items__default_groups (4 columns)
project_email (4 columns), A project's sender email address.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
project_id STRING The unique identifier for the project.
email_address STRING The email address of the project.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_permission_schemes (7 columns), Details about a security scheme.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the issue level security item.
project_id STRING Id of the related project.
id STRING The ID of the issue level security item.
description STRING The description of the issue level security item.
name STRING The name of the issue level security item.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_roles (26 columns), Project Roles
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
admin BOOL Flag indicating if the user has admin role.
current_user_role BOOL The role assigned to the current user.
default BOOL Flag indicating if it is the default role.
description STRING The description of the project role.
id INT64 The ID of the project role.
name STRING The name of the project role.
role_configurable BOOL Flag indicating if the role is configurable.
scope__type STRING The type of scope (e.g., project).
scope__project__self STRING The URL of the project details.
… and 16 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • project_roles__actors (12 columns)
project_types (7 columns), Details about a project type.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING The key of the project type.
formatted_key STRING The formatted key of the project type.
description_i18n_key STRING The key of the project type’s description.
icon STRING The icon of the project type.
color STRING The color of the project type.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
project_versions (21 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Use expand parameter to include additional information about the version in the response. Optional field for creation and update. Expand options include operations and issuesstatus.
self STRING The URL of the version.
id STRING The unique ID of the version.
description STRING The description of the version. Optional field for creating or updating a version.
name STRING The unique name assigned to the version. Required field for version creation, optional for version update. Maximum length is 255 characters.
archived BOOL Indicates whether the version is archived. Optional field for creating or updating a version.
released BOOL Indicates whether the version has been released. A request to release it again will be ignored. Not applicable during version creation. Optional field for version update.
start_date DATE The start date of the version in ISO 8601 format (yyyy-mm-dd). Optional field for creating or updating a version.
release_date DATE The release date of the version in ISO 8601 format (yyyy-mm-dd). Optional field for creating or updating a version.
… and 11 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • project_versions__operations (10 columns)
projects (31 columns), Details about a project.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Expand options that include additional project details in the response.
self STRING The URL of the project details.
id STRING The ID of the project.
key STRING The key of the project.
description STRING A brief description of the project.
lead JSON The username of the project lead.
url STRING A link to information about this project, such as project documentation.
email STRING An email address associated with the project.
assignee_type STRING The default assignee when creating issues for this project.
… and 21 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • projects__components (4 columns)
  • projects__issue_types (4 columns)
  • projects__versions (4 columns)
screen_schemes (9 columns), A screen scheme.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the screen scheme.
name STRING The name of the screen scheme.
description STRING The description of the screen scheme.
screens__edit INT64 The ID of the edit screen.
screens__create INT64 The ID of the create screen.
screens__view INT64 The ID of the view screen.
screens__default INT64 The ID of the default screen. Required when creating a screen scheme.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
screen_tab_fields (6 columns), A screen tab field.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id STRING The ID of the screen tab field.
name STRING The name of the screen tab field. Required on create and update. The maximum length is 255 characters.
screen_id INT64 ID of the related screen.
tab_id INT64 ID of the related tab.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
screen_tabs (5 columns), A screen tab.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the screen tab.
name STRING The name of the screen tab. The maximum length is 255 characters.
screen_id INT64 Id of the related screen.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
screens (20 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the screen.
name STRING The name of the screen.
description STRING The description of the screen.
scope__type STRING The type of scope.
scope__project__self STRING The URL of the project details.
scope__project__id STRING The ID of the project.
scope__project__key STRING The key of the project.
scope__project__name STRING The name of the project.
scope__project__project_type_key STRING The project type of the project.
… and 10 more columns
sprint_issues (24 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
expand STRING Expand options for the issue
id STRING ID of the issue
self STRING URL of the issue
key STRING Key of the issue
fields__flagged BOOL Flag indicating if the issue is flagged
fields__description STRING Description of the issue
fields__created TIMESTAMP Date and time when the issue was created
fields__updated TIMESTAMP Date and time when the issue was last updated
fields__status__description STRING Description of the status
… and 14 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • sprint_issues__fields__comment (3 columns)
  • sprint_issues__fields__worklog (3 columns)
sprints (13 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The unique identifier for the sprint.
self STRING The URL link to fetch more details about the sprint.
state STRING The current state/status of the sprint.
name STRING The name or title of the sprint.
start_date TIMESTAMP The date and time when the sprint is scheduled to start.
end_date TIMESTAMP The date and time when the sprint is expected to end.
complete_date TIMESTAMP The date and time when the sprint was completed.
origin_board_id INT64 The original board ID the sprint belongs to.
board_id INT64 Used to determine which board the sprint is a part of. (Not always the same as originBoardId)
… and 3 more columns
time_tracking (5 columns), Details about the time tracking provider.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
key STRING The key associated with the time tracking provider.
name STRING The name of the time tracking provider.
url STRING The URL of the configuration page for the time tracking provider app. This property is only returned if the `adminPageKey` property is set in the module descriptor of the time tracking provider app.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
users (21 columns), A user with details as permitted by the user's Atlassian Account privacy settings. However, be aware of these exceptions: * User record deleted from Atlassian: This occurs as the result of a right to be forgotten request. In this case, `displayName` provides an indication and other parameters have default values or are blank (for example, email is blank). * User record corrupted: This occurs as a results of events such as a server import and can only happen to deleted users. In this case, `accountId` returns *unknown* and all other parameters have fallback values. * User record unavailable: This usually occurs due to an internal service outage. In this case, all parameters have fallback values.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the user.
key STRING Deprecated property. See the deprecation notice for details.
account_id STRING The account ID of the user, uniquely identifying the user across all Atlassian products. Required in requests.
account_type STRING The user account type. Can be one of: - `atlassian`: regular Atlassian user account - `app`: system account used for Connect applications and OAuth - `customer`: Jira Service Desk account representing an external service desk
name STRING Deprecated property. See the deprecation notice for details.
email_address STRING The email address of the user. May be null based on privacy settings.
avatar_urls___16x16 STRING The URL of the 16x16 pixel avatar.
avatar_urls___24x24 STRING The URL of the 24x24 pixel avatar.
avatar_urls___32x32 STRING The URL of the 32x32 pixel avatar.
… and 11 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • users__groups__items (5 columns)
  • users__application_roles__items (13 columns)
  • users__application_roles__items__groups (4 columns)
  • users__application_roles__items__default_groups (4 columns)
users_groups_detailed (21 columns), A user with details as permitted by the user's Atlassian Account privacy settings. However, be aware of these exceptions: * User record deleted from Atlassian: This occurs as the result of a right to be forgotten request. In this case, `displayName` provides an indication and other parameters have default values or are blank (for example, email is blank). * User record corrupted: This occurs as a results of events such as a server import and can only happen to deleted users. In this case, `accountId` returns *unknown* and all other parameters have fallback values. * User record unavailable: This usually occurs due to an internal service outage. In this case, all parameters have fallback values.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the user.
key STRING This property is no longer available and will be removed from the documentation soon. See the deprecation notice for details.
account_id STRING The account ID of the user, uniquely identifying the user across all Atlassian products. Required in requests.
account_type STRING The user account type. Possible values are ‘atlassian’ for regular Atlassian user account, ‘app’ for a system account used for Connect applications and OAuth, and ‘customer’ for a Jira Service Desk account representing an external service desk.
name STRING This property is no longer available and will be removed from the documentation soon. See the deprecation notice for details.
email_address STRING The email address of the user. Depending on the user’s privacy setting, this may be returned as null.
avatar_urls___16x16 STRING The URL of the item’s 16x16 pixel avatar.
avatar_urls___24x24 STRING The URL of the item’s 24x24 pixel avatar.
avatar_urls___32x32 STRING The URL of the item’s 32x32 pixel avatar.
… and 11 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • users_groups_detailed__groups__items (6 columns)
  • users_groups_detailed__application_roles__items (13 columns)
  • users_groups_detailed__application_roles__items__groups (4 columns)
  • users_groups_detailed__application_roles__items__default_groups (4 columns)
workflow_schemes (30 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id INT64 The ID of the workflow scheme.
name STRING The name of the workflow scheme. The name must be unique. The maximum length is 255 characters. Required when creating a workflow scheme.
description STRING The description of the workflow scheme.
default_workflow STRING The name of the default workflow for the workflow scheme. The default workflow has *All Unassigned Issue Types* assigned to it in Jira. If `defaultWorkflow` is not specified when creating a workflow scheme, it is set to *Jira Workflow (jira)*.
original_default_workflow STRING For draft workflow schemes, this property is the name of the default workflow for the original workflow scheme. The default workflow has *All Unassigned Issue Types* assigned to it in Jira.
draft BOOL Whether the workflow scheme is a draft or not.
last_modified_user__self STRING The URL of the user.
last_modified_user__key STRING This property is no longer available and will be removed from the documentation soon. See the [deprecation notice](https://developer.atlassian.com/cloud/jira/platform/deprecation-notice-user-privacy-api-migration-guide/) for details.
last_modified_user__account_id STRING The account ID of the user, which uniquely identifies the user across all Atlassian products. For example, *5b10ac8d82e05b22cc7d4ef5*. Required in requests.
… and 20 more columns

Repeating fields are split into their own tables, listed here with their column counts.

  • workflow_schemes__last_modified_user__groups__items (5 columns)
  • workflow_schemes__last_modified_user__application_roles__items (13 columns)
  • workflow_schemes__last_modified_user__application_roles__items__groups (4 columns)
  • workflow_schemes__last_modified_user__application_roles__items__default_groups (4 columns)
workflow_status_categories (7 columns), A status category.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the status category.
id INT64 The ID of the status category.
key STRING The key of the status category.
color_name STRING The name of the color used to represent the status category.
name STRING The name of the status category.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.
workflow_statuses (13 columns), A status.
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
self STRING The URL of the status.
description STRING The description of the status.
icon_url STRING The URL of the icon used to represent the status.
name STRING The name of the status.
id STRING The ID of the status.
status_category__self STRING The URL of the status category.
status_category__id INT64 The ID of the status category.
status_category__key STRING The key of the status category.
status_category__color_name STRING The name of the color used to represent the status category.
… and 3 more columns
workflows (9 columns)
Column Type Description
_kaivo_id STRING Primary key that uniquely identifies the row. Auto-generated by Kaivo.
id__entity_id STRING
id__name STRING The name of the workflow.
entity_id STRING The unique identifier of the workflow.
name STRING The unique name the workflow.
description STRING The detailed description of the workflow.
created TIMESTAMP The date and time when the workflow was created.
updated TIMESTAMP The date and time when the workflow was last updated.
_kaivo_extracted_at TIMESTAMP Timestamp that shows when the row was extracted. Auto-generated by Kaivo.

Repeating fields are split into their own tables, listed here with their column counts.

  • workflows__transitions (9 columns)
  • workflows__transitions__from (4 columns)
  • workflows__transitions__rules__conditions (5 columns)
  • workflows__transitions__rules__validators (5 columns)
  • workflows__transitions__rules__post_functions (5 columns)
  • workflows__statuses (6 columns)

After the first load, Kaivo keeps your BigQuery warehouse up to date for you. Where Jira supports it, each sync pulls only new and changed records so it stays fast; otherwise it refreshes the whole table. Every record keeps its original ID, so you won’t get duplicate rows.

How long does the initial sync take for Jira?

Section titled “How long does the initial sync take for Jira?”

It depends on how much history is in your Jira account. Most initial syncs finish within minutes, while large accounts can take a few hours. After that, syncs only fetch new and changed records, so they’re much faster.

Yes. You pick which tables to sync when you set up the connection and can change the selection later. Tables you don’t select are never copied to your warehouse.

What happens when Jira’s schema changes?

Section titled “What happens when Jira’s schema changes?”

New fields are never added automatically. You choose which fields to sync, so data you haven’t selected (sensitive personal data, for example) never lands in your warehouse. When a new field appears, it becomes available for you to add. What happens to removed or renamed fields depends on a table’s sync mode: full-refresh tables always match what’s currently in Jira, so dropped fields disappear, while incremental tables keep their existing columns and history, so an old field stays and newly added fields fill in over time.

How do I handle GDPR or data deletion requests?

Section titled “How do I handle GDPR or data deletion requests?”

Your data lives in your own Kaivo-managed BigQuery warehouse, so the most direct option is to delete or anonymise specific records right in BigQuery. If you delete data in Jira instead, full-refresh tables drop it on the next sync, while incremental tables keep it, so you would remove the row in BigQuery or ask us to run a full refresh. To remove everything, delete the Jira connector in Kaivo and all of its synced data is deleted with it.

Combine issues with sprints and boards to measure velocity, scope changes, and completion rates across teams and over time.

Use issue created, updated, and resolution dates to estimate cycle and lead time and spot where work stalls in the workflow.

Track issues by status, priority, and issue type to monitor backlog growth, throughput, and the mix of work being delivered.

Aggregate worklogs by user, project, and issue to report logged time and how effort is distributed across initiatives.

Join Jira issues with data from your other tools in BigQuery to build delivery dashboards that span product, support, and engineering.

Once Jira data lands in your Kaivo-managed BigQuery warehouse, you can explore it with AI tools or any BI tool that connects to BigQuery. Here’s how the most common destinations work with Jira data.

Use Kaivo’s MCP server to give Claude secure, workspace-scoped access to your data. Setup guide →

Microsoft’s BI tool with a native BigQuery connector. Supports direct query and scheduled refresh. Setup guide →

Free Google BI tool with native BigQuery support. One-click connection to your Kaivo warehouse; great for SMB teams on Google Workspace. Setup guide →

The premium analytics standard, with native BigQuery integration. Setup guide →

Use Connected Sheets to query BigQuery directly from a spreadsheet, with no SQL. Setup guide →

Connect via Power Query’s BigQuery connector. Setup guide →

Open-source BI tool with strong BigQuery support. Setup guide →

See our pricing page for Jira connector pricing and plan details.