Jira connector reference

Beta

The Jira connector is in Beta.

This page contains reference material for the Jira connector in Databricks Lakeflow Connect.

Supported Jira source tables for ingestion

The following source tables can be ingested with the Jira connector. For each table, ensure that your Jira OAuth application has the necessary scopes, and that the user (or service principal account) creating the Unity Catalog connection has the necessary roles and permissions.

Table name	Description	Supported ingestion model	Required OAuth scopes	Required roles and permissions for the authenticating user
application_roles	Application role details	Full refresh only	read:application-role:jira	ADMINISTER GLOBAL permission
boards	Details related to dashboards	Full refresh only	read:board-scope.admin:jira-software, read:project:jira
issue_comments	Comments attached to Jira issues	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
issue_field_values	Values for the system fields and custom fields present in the fields table	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
issue_fields	Metadata for system fields and custom fields - their ID, name, description	Full refresh only	read:jira-work	BROWSER PROJECTS permission
issue_links	Details of links between issues	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
issue_types	List of issue types	Full refresh only	read:jira-work	PROJECT permissions
issue_watchers	List of watcher user IDs per issue ID	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
issue_worklogs	Worklogs of issues	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
issues	Data on all issues (also known as work items)	Incremental (SCD 1 or SCD 2)	read:jira-work	ADMINISTER GLOBAL permission
permission_schemes	List of permission schemes	Full refresh only	read:application-role:jira, read:field:jira, read:group:jira, read:permission-scheme:jira, read:permission:jira, read:project-role:jira, read:user:jira, read:avatar:jira, read:project-category:jira, read:project:jira	ADMINISTER GLOBAL permission
priority	Issue priorities	Full refresh only	read:jira-work	PERMISSION to access Jira
project_board	project_id and board_id relationships	Full refresh only	read:board-scope.admin:jira-software, read:project:jira
project_categories	Categories of projects	Full refresh only	read:project-category:jira	PERMISSION to access Jira
project_components	Components of projects	Full refresh only	read:jira-work	BROWSER PROJECTS permission
project_permissions	Details of all permissions and determine whether the user has certain permissions	Full refresh only	read:application-role:jira, read:field:jira, read:group:jira, read:permission-scheme:jira, read:permission:jira, read:project-role:jira, read:user:jira, read:avatar:jira, read:project-category:jira, read:project:jira	ADMINISTER GLOBAL permission
project_role_actor	Users assigned to project roles	Full refresh only	read:user:jira, read:group:jira, read:project-role:jira, read:project:jira, read:avatar:jira, read:project-category:jira	ADMINISTER GLOBAL permission
project_roles	List of the roles that users can play in projects	Full refresh only	read:user:jira, read:group:jira, read:project-role:jira, read:project:jira, read:avatar:jira, read:project-category:jira	ADMINISTER GLOBAL permission
projects	Details of your Jira projects	Full refresh only	read:jira-work	One of BROWSER PROJECTS, ADMINISTER PROJECTS, ADMINISTER GLOBAL
resolutions	All issue resolution values and the details of individual resolution values	Full refresh only	read:jira-work	PERMISSION to access Jira
security_level	List of issue security levels	Full refresh only	read:issue-security-level:jira, read:issue-security-scheme:jira	ADMINISTER GLOBAL permission
security_schemes	List of issue security schemes	Full refresh only	read:issue-security-level:jira, read:issue-security-scheme:jira	ADMINISTER GLOBAL permission
sprints	Data about sprints	Full refresh only	read:sprint:jira-software, read:board-scope.admin:jira-software, read:project:jira	READ permission
status	Data about statuses	Full refresh only	read:workflow:jira, read:status:jira	ADMINISTER PROJECTS permission
status_category	Status categories	Full refresh only	read:workflow:jira, read:status:jira	ADMINISTER PROJECTS permission
user_group	Groups of users	Full refresh only	read:jira-user, read:group:jira	BROWSE Users and Groups permission
users	Users in the Jira instance (only those visible to the connection user)	Full refresh only	read:jira-user	BROWSE Users and Groups permission
version	Project versions	Full refresh only	read:jira-work	BROWSER Projects permission