Jira connector

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

Written By Lauri Raivio

Last updated 16 days ago

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.

What is the Jira connector

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

Getting started with the Jira connector

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.

Authenticating Jira

Authenticate with your API Token.

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

Configuring the Jira connector

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.

Tables and columns synced from Jira

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

Nested subtables

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

Nested subtables

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

Nested subtables

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)

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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.

Nested subtables

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.

Nested subtables

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.

Nested subtables

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

Nested subtables

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

Nested subtables

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.

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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

Nested subtables

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.

Nested subtables

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)

How the Jira sync works

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.

Frequently asked questions

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.

Can I sync only some tables or columns?

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?

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.

Common use cases for Jira data

Sprint velocity

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

Cycle and lead time

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

Backlog and throughput

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

Time reporting

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

Cross-tool delivery reporting

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

Use Jira data in your AI and BI tools

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.

Claude

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

Power BI

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

Data Studio

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

Tableau

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

Google Sheets

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

Excel

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

Metabase

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

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

ClickUp: Sync ClickUp to BigQuery.
GitHub: Sync GitHub to BigQuery.
GitLab: Sync GitLab to BigQuery.
Harvest: Sync Harvest to BigQuery.
Kellokortti: Sync Kellokortti to BigQuery.
Linear: Sync Linear to BigQuery.

Was this helpful?

Still need help? Share an idea

What is the Jira connector

Getting started with the Jira connector

Authenticating Jira

Configuring the Jira connector

Tables and columns synced from Jira

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

Nested subtables

How the Jira sync works

Frequently asked questions

How long does the initial sync take for Jira?

Can I sync only some tables or columns?

What happens when Jira's schema changes?

How do I handle GDPR or data deletion requests?

Common use cases for Jira data

Sprint velocity

Cycle and lead time

Backlog and throughput

Time reporting

Cross-tool delivery reporting

Use Jira data in your AI and BI tools

Claude

Power BI

Data Studio

Tableau

Google Sheets

Excel

Metabase

Related connectors