Schema for Confluence

If you add Confluence data to an Atlassian Data Lake connection, you can query that data from the following tables:

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 comment data

Comment

The confluence_comment table lists all comments made on pages, blog posts, and attachments. It uses the following columns:

Body*

The body of the comment, stored in a JSON object.

SQL name	body
Data type	String

Comment ID

The unique identifier of the comment. Use this as the primary key for comment data.

SQL name	comment_id
Data type	String

Created at

The date and time (UTC time zone) when the comment was created.

SQL name	created_at
Data type	Datetime

Created by*

The unique identifier of the person who created the comment.

SQL name	created_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Parent title*

The title of the page, blog post, or attachment that the comment is on.

SQL name	parent_title
Data type	String

Page ID

The unique identifier of the page or blog post that contains the comment.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Parent attachment ID

The parent attachment of the comment.

The comment can have zero or one parent attachment.

SQL name	parent_attachment_id
Data type	String

Parent comment ID

The parent comment of the comment.

The comment can have zero or one parent comment.

SQL name	parent_comment_id
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Space ID

The unique identifier of the space that contains the comment.

SQL name	space_id
Data type	String
Foreign key	Links to a record in the confluence_space table.

Status*

The status of the comment.

SQL name	status
Data type	String
Example values	draft, current, archived

Updated at

The date and time (UTC time zone) when the comment was last updated.

SQL name	updated_at
Data type	Datetime

Updated by

The unique identifier of the person who updated the comment. For example, an admin can delete someone else’s comment.

SQL name	updated_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

URL

The URL of the comment.

SQL name	url
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.

Tables for page and blog post data

Data for both pages and blog posts are aggregated into the following tables:

Page
Page contributor mapping
Page favorited by mapping
Page label
Page property
Page restriction
Page updated by mapping
Page watcher mapping

To filter for only page data or only blog post data, use the Type column from the Confluence page table in the “Filters” section of your visual mode queries or the WHERE clause of your SQL mode queries.

Page

The confluence_page table lists your pages and blog posts.

The table uses the following columns:

Body*

The body content of the page or blog post, stored as a JSON object.

SQL name	body
Data type	String

Created at

The date and time (UTC time zone) when the page or blog post was created.

SQL name	created_at
Data type	Datetime

Created by*

The unique identifier of the person who created the page or blog post.

SQL name	created_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Icon URL*

The URL of the icon for the page or blog post.

SQL name	icon_url
Data type	String

Language*

The language that the page or blog post is displayed in.

SQL name	language
Data type	String

Page ID

The unique identifier of the page or blog post. Use this as the primary key for page or blog post data.

SQL name	page_id
Data type	String

Parent page ID*

The unique identifier of the parent page in the page hierarchy.

Blog posts will not have a parent page.

SQL name	parent_page_id
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Space ID

The unique identifier of the space that contains the page or blog post.

SQL name	space_id
Data type	String
Foreign key	Links to a record in the confluence_space table.

Status*

The current status of the page or blog post.

SQL name	status
Data type	String
Example values	archived, current, draft, trash

Title*

The title of the page or blog post.

SQL name	title
Data type	String

Type*

Specifies if the content is a page or a blog post.

Use the Type column to filter for only page data or only blog post data.

SQL name	type
Data type	String
Example values	page, blogpost

Updated at

The date and time (UTC time zone) when the page or blog post was last updated.

SQL name	updated_at
Data type	Datetime

URL

The URL of the page or blog post.

SQL name	url
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.

Page contributor mapping

The confluence_page_contributor_mapping table holds associations between pages/blog posts and all accounts that have contributed to them.

The table uses the following columns:

Account ID

The unique identifier of the page or blog post contributor.

SQL name	account_id
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Page favorited by mapping

The confluence_page_favorited_by_mapping table holds associations between pages/blog posts and accounts that have favorited them. It uses the following columns:

Account ID

The unique identifier of the person who favorited the page or blog post.

SQL name	account_id
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Page label

The confluence_page_label table lists the labels associated with a page or blog post.

The table uses the following columns:

Name*

The name of the page or blog post label.

SQL name	name
Data type	String

Namespace*

Helps determine the visibility of the label.

SQL name	namespace
Data type	String

Owned by*

The unique identifier of the person who associated the label to the page or blog post.

SQL name	owned_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Page property

The confluence_page_property table lists extra properties associated with a page or blog post, stored in key-value pairs.

The table uses the following columns:

Key*

The key of the property.

SQL name	key
Data type	String

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Value*

The value of the property.

SQL name	value
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.

Page restriction

The confluence_page_restriction table lists the restrictions that have been configured for each page or blog post.

The table uses the following columns:

Authorized account*

The unique identifier of the person who has permission to view or edit the page or blog post.

SQL name	authorized_account
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Authorized team*

The unique identifier of the team that has permission to view or edit the page or blog post.

SQL name	authorized_team
Data type	String
Foreign key	Links to a record in the atlassian_group table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Restriction type*

The type of restriction applied to the page or blog post viewer.

SQL name	restriction_type
Data type	String
Example values	Our team is working to resolve an issue where the restriction type always shows view even if the person has permission to edit. view, edit

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Page updated by mapping

The confluence_page_updated_by_mapping table holds associations between pages/blog posts and accounts that have most recently updated them.

The table uses the following columns:

Account ID

The unique identifier of the person who last updated the page or blog post.

SQL name	account_id
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Page watcher mapping

The confluence_page_watcher_mapping table holds associations between pages/blog posts and accounts that have watched them.

The table uses the following columns:

Account ID

The unique identifier of the person who watched the page or blog post.

SQL name	account_id
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Page ID

The unique identifier of the page or blog post.

SQL name	page_id
Data type	String
Foreign key	Links to a record in the confluence_page table.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

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.

Tables for space data

There are several tables for space data:

Space
Space label
Space viewer mapping

Space

The confluence_space table lists your spaces.

The table uses the following columns:

Created at

The date and time (UTC time zone) when the space was created.

SQL name	created_at
Data type	Datetime

Created by*

The unique identifier of the person who created the space.

LSQL name	created_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Description*

The description of the space.

SQL name	description
Data type	String

Homepage ID*

The unique identifier of the homepage.

SQL name	homepage_id
Data type	String

Icon URL*

The URL of the page icon.

SQL name	icon_url
Data type	String

Key*

The key of the space.

SQL name	key
Data type	String

Name*

The name of the space.

SQL name	name
Data type	String

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Space ID

The unique identifier of the space.

SQL name	space_id
Data type	String

Status*

The current status of the space.

SQL name	status
Data type	String
Example values	archived, current

Type*

The type of space.

SQL name	type
Data type	String
Example values	personal, global

Updated at

The date and time (UTC time zone) when the space was last updated.

SQL name	updated_at
Data type	Datetime

Updated by

The unique identifier of the person who last updated the space.

SQL name	updated_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

URL

The URL of the space.

SQL name	url
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.

Space label

The confluence_space_label table lists the labels associated with a space.

The table uses the following columns:

Name*

The name of the space label.

SQL name	name
Data type	String

Namespace*

Helps determine the visibility of the label.

SQL name	namespace
Data type	String

Owned by*

The unique identifier of the person who associated the label to the space.

SQL name	owned_by
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Space ID

The unique identifier of the space.

SQL name	space_id
Data type	String
Foreign key	Links to a record in the confluence_space table.

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.

Space viewer mapping

The confluence_space_viewer_mapping table holds associations between spaces and accounts that can view them.

The table uses the following columns:

Account ID

The unique identifier of the person who can view the space.

SQL name	account_id
Data type	String
Foreign key	Links to a record in the account table in the schema for organization data.

Row refreshed at

The last refresh time (UTC time zone) for this record.

SQL name	row_refreshed_at
Data type	Datetime

Space ID

The unique identifier of the space.

SQL name	space_id
Data type	String
Foreign key	Links to a record in the confluence_space table.

Team ID

The unique identifier of the team that can view the space.

SQL name	team_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?

It wasn't accurate

It wasn't clear

It wasn't relevant