Connect your data to Atlassian Analytics
Learn how to connect and manage your connected Atlassian data and external data.
Only customers with a Cloud Enterprise plan for Jira Software or Jira Service Management have access to Atlassian Analytics.
Each product has its own set of tables and columns in the Atlassian Data Lake. If you choose to include all data for your products, more columns are added to each of those tables.
Only data for Jira Software, Jira Service Management, Jira Work Management, and Opsgenie are available in the Atlassian Data Lake at this time. Data for more products are coming soon.
The product tables capture product data in a star schema, meaning some tables refer to other tables. Because of this, you may need to join multiple queries to get the data you need in Atlassian Analytics.
These tables rapidly reflect changes in your products, typically within half an hour. This makes them especially useful for custom analysis, or when having the most up-to-date information is important.
Keep in mind that all columns with dates and timestamps (for example, created_at, updated_at, and so on) are in the UTC time zone. To convert these to use a different time zone, either change your workspace time zone in your workspace settings or the individual dashboard’s time zone in its dashboard settings.
Schema for organization data
Understand how your organization's data is captured in the Atlassian Data Lake.
Schema for Jira family of products
Understand how Jira data is captured in the Atlassian Data Lake.
Schema for Jira Software
Understand how your project data for Jira Software is captured in the Atlassian Data Lake.
Schema for Jira Service Management
Understand how your project data for Jira Service Management is captured in the Atlassian Data Lake.
Schema for asset and configuration management
Understand how your data for asset and configuration management in Jira Service Management is captured in the Atlassian Data Lake.
Schema for Confluence
Understand how Confluence data is captured in the Atlassian Data Lake.
Was this helpful?