Tina Ling Atlassian Team

Hi community! Jira Board related tables, Jira Filters table and a new 'Activated at' column in the Sprint table are now available in Analytics and data share. These additions make it possible to understand Jira Board attributes, Board - Project relationships, and the actual moment a Sprint started. For Analytics, the…

Hi community! A group of key Jira configuration tables are now available! These data points represent the core building blocks used to define how work is structured and managed within Jira. Jira Workflow, Work Item Type and Work Item Status: Define the lifecycle, available Work Item Type and Status of work. Workflow Scheme…

Hi, community! New Jira entity properties data is now available on Analytics and Data Share. These new tables expose key-value property data that apps, integrations, automations, and Jira use to store extra configuration or metadata on Jira entities, Jira Entity Properties. With these tables, you can query property keys…

Hi, community! Jira Forge custom fields data is now available on Analytics and data share. Forge custom fields are special types of custom fields created by Forge apps. These fields are added to Jira work items via the Jira Forge platform. The new data will be rolled out gradually in the coming 2-3 weeks. Where to find…

Hi community, We plan to make these changes in the coming months. Removal of the Scope mode column in the Team table Removal of the Role column in the Team member table Value change in the Page viewed ID column in the Page viewed table under Confluence schema Upcoming deprecations - 2nd notice Scope mode column in the Team…

Hi, community! Two new Jira tables are now available on Analytics App: ‘Work item sprint mapping’, under Jira schema 'Work item hierarchy', under Jira Family of Apps schema Both tables are meant to simplify the current query logic if you need to report on Sprint<>Work item or Jira work item hierarchy. The new tables will…

Hi, community! We’re introducing new data for Teams and Jira spaces: New columns / table for information about team types “Managed by” column for Jira spaces (highly requested!) We also want to notify you that we’re planning to deprecate a few team-related data values. The new data and deprecated values apply to both…

Hi, community! Event data for views of Confluence pages and blog posts is available in Analytics through the new Page viewed table. You’ll find it under the Confluence category in the schema browser. Key columns explained “Page viewed ID” is the primary key. It represents one unique combination of a view action and page…

Hi, Community! Goals and Atlassian Projects data can now be queried in the Analytics app. This data gives you visibility into organizational-level work progress by connecting the dots among goals, contributing work items, teams, and contributors. The new data is organized into 3 new schema categories: Goals - includes goal…

Hi, community! A while ago, we made efficiency changes to 5 of our most commonly queried Jira tables. This significantly improved their query performance, but it also impacted the freshness of their data. We’ve heard your feedback about needing to report with fresher data, so we’re introducing new versions for 4 of those 5…

Hi, community! We’re excited to announce that Jira work log and linked issues data are now available in Atlassian Analytics. You’ll find two new tables under “Jira family of products”: Issue worklog Issue link The “Issue worklog” table lets you drill deeper into development velocity by breaking resource allocation down by…

Hi, community! We’re releasing new columns that will enable you to filter out archived or deleted Jira projects, group by issue type hierarchies, and more! These columns will be available in both Atlassian Analytics and in data shares. We’ll gradually roll out the new columns over the next week. New columns in the…

Hi community, March 31, 2025 update We’ve started rolling out the removal of the 7 tables and “Authorized team” column. By the end of this week, you’ll no longer be able to query these tables or column, and any queries that still use them will break. What you need to do First, make sure to use the replacement “Content”…

Hi, community! We're bringing three more Jira issue fields into the Atlassian Data Lake: Major incident Target start Target end We’ll gradually roll out these new fields over the coming 2 weeks. Where to find these new fields In Atlassian Analytics "Is major incident" column and "Major incident' field You’ll find a new Is…

Hi community, We want to let you know that we’re going to roll out major backend changes to a few Jira tables in the Atlassian Data Lake. These changes will enable us to improve the coverage of issue change events in Jira Issue History table, as well as fix an existing bug regarding missing data and ensure more accurate…

Hello, community! 👋 By popular demand, we're releasing two new data points to the Atlassian Data Lake: groups and teams. Group data is stored in the new Group table, which holds the mappings between group IDs and group names. Team data is stored in two new tables: Team and Team member. The “Team” table holds the mapping…

Hi, community! We're releasing these new data points and enhancements starting today: "Is archived" column in the "Jira issue" table - for archived issue New "Jira component" table - for Compass components Enhancement to the existing "Story points" column in the "Jira issue" table 🎥 Video example Here’s a demo with an…

Hi, community! To further empower Cloud Enterprise admins in managing Atlassian products, we’ve released two dashboard templates to bring more visibility into your organization’s Jira and Confluence usage: Confluence - Usage of extensions, links, and mentions Jira engagement metrics Confluence - Usage of extensions,…

Hi everyone, As we announced in July, we're deprecating seven Confluence page-specific tables in the Atlassian Data Lake and replacing them with broader content tables. We plan to deprecate the tables on February 4, 2025. Adjust your queries and dashboards before this date. Otherwise, your charts querying the old tables…

Hi, community! You can now report on user @mentions from Confluence pages, blog posts, and comments using these two new tables: * Comment mentions mapping: for users mentioned in comments * Content mentions mapping: for users mentioned directly in pages and blog posts Comment mentions mapping The Comment mentions mapping…

Hi, community! Several weeks ago, we shared that we were working on two new tables. We’re happy to announce that they're now available! * Issue group mapping is now available in Atlassian Analytics. * Atlassian_group is now available in data shares. “Issue group mapping” is a flattened table that maps each issue ID to all…

Hi community, The “Group picker (single group)” and “Group picker (multiple groups)” fields from the Jira “Issue field” table now stores group IDs, instead of names. This change applies to both Atlassian Data Lake connections in Atlassian Analytics and data shares. To report on group names, please join the Jira “Issue…

Hi everyone, We're happy to announce that you can now find data on Jira issues associated with a team! This was a highly requested data point and will enable you to better report on your Jira issues. We’ve added a new Team ID column to the “Issue” table under “Jira family of products”, which gives you a one-to-one mapping…

Hi, community! A new set of Confluence dashboard and chart templates are now available! These templates use data from our recently launched Confluence tables to help reveal information about storage, permissions, and key user activities. They're a good starting point, especially for organization admins, if you want to…

Hi community, We want to give you advance notice that we’re going to roll out major backend changes to the Jira tables in the Atlassian Data Lake. These changes will enable us to bring even more Jira data into Atlassian Analytics. Impact on usage We don’t expect these changes to impact you, but if you notice anything…

Hi community, More Confluence data has come into Atlassian Analytics! New tables for Confluence attachments, whiteboards, databases and space permission are now available. On top of this, we’ve also added new attribute columns to existing Confluence tables. With these new data points, you'll be able to see a deeper picture…

Hi community, We have two updates to share about querying issue Story point estimate and Priority in Atlassian Analytics. Story points can now be queried directly from the Jira family of products “Issue” table We're happy to share that a new “Story points” column is now added to the “Issue” table under Jira family of…

We’ve got two exciting updates to share about Atlassian account data in the Atlassian Data Lake: Rolling out data for unmanaged accounts We're happy to share that we’ve started rolling out data for unmanaged accounts! At some point during this rollout period, you’ll see rows for both managed and unmanaged accounts in the…

Hello everyone, A couple of weeks ago, we announced that we'd make efficiency changes to the "Issue field" table in the Atlassian Data Lake schema. These changes are now live, so you should see faster query performance and dashboard loading times when you query this table. Update on data freshness The data in this table…

What’s coming A couple of months ago, we made efficiency changes to four Jira tables. Since then, we’ve observed significant improvement in query performance on Atlassian Analytics. To have a wider range of queries benefit from a faster turnaround time, we're introducing the same efficiency changes to the jira_issue_field…