• Products
  • Documentation
  • Resources

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

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

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.

Additional Help