Upcoming removal of Confluence page-specific tables and "Authorized team" column

[#1]

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. Please adjust your queries and dashboards before this date. Otherwise, your charts querying the old tables will return errors.

What’s changing

These seven Confluence page-specific tables are being deprecated and replaced by broader content tables. The content tables include information for all Confluence items, including pages, blog posts, whiteboards, and databases.

Here’s how the data from the page-specific tables maps to the newer content tables:

Page tables (to be removed)	Content tables (replacement)
Page contributor mapping	Content contributor mapping
Page favorited by mapping	Content favorited by mapping
Page label	Content label
Page property	Content property
Page restriction (also see note about the "Authorized team" column below)	Content restriction
Page updated by mapping	Content updated by mapping
Page watcher mapping	Content watcher mapping

To filter for only page data in these tables, you can use Page ID is not null in your query filters or use the “Page ID” column to join any of these tables with the “Page” table.

For example, to get the number of unique labels used across all pages or blog posts, you could create the following query where you:

• add the Name column from the Content label table

• select Count of unique from its aggregation menu

• add Page ID is not null to your query filter

For more examples of how to use the new tables, check out our video from our earlier announcement.

New “Authorized group” column in “Content restriction” table to replace “Authorized team” column

The “Authorized team” column in the “Page restriction” table will be replaced by the “Authorized group” column in the newer “Content restriction” table.

To answer questions about page restrictions for a particular group, you can join the “Group ID” column in the “Group” table with the “Authorized group” column in the “Content restriction” table.

What you need to do

When the tables are deprecated, any queries that use those tables will break. Adjust your queries to use the newer content tables to ensure there are no disruptions to your workflow.

You can search your queries to quickly check if you have any queries that reference the old page tables.

When to expect these changes

This table deprecation will happen on February 4, 2025.

Comment below or contact support if you have any questions or concerns. Thanks!