Connect your data to Atlassian Analytics
Learn how to connect and manage your connected Atlassian data and external data.
Atlassian Analytics is in open beta
Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.
Schema for Jira Software
In addition to the tables for the Jira family of products, Jira Software has extra tables added to the Atlassian Data Lake schema.
Columns with an asterisk (*) are only available when you include all data for your products in a Data Lake connection. Learn more about how to set the scope of data for Atlassian Data Lake connections.
Table for issue estimate history data
Issue estimate history
The jsw_issue_estimate_history table tracks changes in issue estimate data over time. Specifically, it tracks changing in Jira’s Original time estimate field or fields that have “story point” in their name.
Arbitrary custom fields configured in Jira Software boards are not yet supported.
The table uses the following columns:
Author account ID*
The unique identifier of the person who updated the issue estimate.
SQL name | author_account_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table in the schema for organization data. |
Ended at
The date and time (UTC time zone) when the new field value was replaced by another.
It is NULL if there was no subsequent change.
SQL name | ended_at |
|---|---|
Data type | Datetime |
Estimate*
The issue estimate after the change.
SQL name | estimate |
|---|---|
Data type | Number |
Field ID
The unique identifier of the estimate field.
SQL name | field_id |
|---|---|
Data type | String |
Field name*
The name of the estimate field that was updated.
SQL name | field_name |
|---|---|
Data type | String |
Issue ID
The unique identifier of the issue that was updated.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table in the schema for Jira family of products. |
Previous estimate*
The issue estimate before the change.
SQL name | prev_estimate |
|---|---|
Data type | Number |
Started at*
The date and time (UTC time zone) when the new estimate value was assigned.
SQL name | started_at |
|---|---|
Data type | Datetime |
Time in estimate (seconds)
The time interval (in seconds) between the start and end time of the estimate value captured by this record.
It is NULL if there was no subsequent estimate change (in other words, the new estimate is the current one).
SQL name | time_in_estimate_secs |
|---|---|
Data type | Number |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Table for issue sprint history data
Issue sprint history
The jsw_issue_sprint_history table tracks changes in issue allocation to sprints over time
The table uses the following columns:
Action
Indicates whether the issue was added or removed from a sprint.
SQL name | action |
|---|---|
Data type | String |
Example values | added, removed |
Action at
The date and time (UTC time zone) when the issue was added or removed from a sprint.
SQL name | action_at |
|---|---|
Data type | Datetime |
Author account ID*
The unique identifier of the person who changed the issue allocation to a sprint.
SQL name | author_account_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the account table in the schema for organization data. |
Issue ID
The unique identifier of the issue that was allocated to a sprint.
SQL name | issue_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the jira_issue table in the schema for Jira family of products. |
Sprint ID
The unique identifier of the sprint that the issue was added to or removed from.
SQL name | sprint_id |
|---|---|
Data type | String |
Workspace ID
An Atlassian identifier that maps data to a site in the workspace table
SQL name | workspace_id |
|---|---|
Data type | String |
Foreign key | Links to a record in the workspace table in the schema for organization data. |
Was this helpful?