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.
| Category | Project Management |
|---|
| Authentication | API key |
|---|
| Setup | Self-service |
|---|
- Sign up for Kaivo and create a workspace.
- Connect your Jira account.
- Choose which tables to sync.
- Wait for the initial sync to finish.
- 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.
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.
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.
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.