• 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.

Tables for attachment data

There are several tables for attachment data:

  • Attachment

  • Attachment label

  • Attachment property

Attachment

The confluence_attachment table lists the attachments uploaded to your pages, blog posts, databases, whiteboards, or spaces.

The table uses the following columns:

Attachment ID

The unique identifier of the attachment.

SQL name

attachment_id

Data type

String

Created at

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

SQL name

created_at

Data type

Datetime

Created by

The unique identifier of the person who created the attachment.

SQL name

created_by

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

File extension*

The file extension of the attachment.

SQL name

file_extension

Data type

String

File size*

The file size (in bytes) of the attachment.

SQL name

file_size

Data type

Number

Media type*

The media type of the attachment.

SQL name

media_type

Data type

String

Name*

The file name of the attachment.

SQL name

name

Data type

String

Parent database ID

The unique identifier of the Confluence database that the attachment is part of.

SQL name

parent_database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Parent page ID

The unique identifier of the Confluence page or blog post that the attachment is part of.

SQL name

parent_page_id

Data type

String

Foreign key

Links to a record in the confluence_page table.

Parent space ID

The unique identifier of the Confluence space that the attachment is part of. This is only set when the parent of the attachment is only the space and not any other type of content.

SQL name

parent_space_id

Data type

String

Foreign key

Links to a record in the confluence_space table.

Parent whiteboard ID

The unique identifier of the Confluence whiteboard that the attachment is part of.

SQL name

parent_whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard table.

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 Confluence space.

SQL name

space_id

Data type

String

Foreign key

Links to a record in the confluence_space table.

Status*

The unique identifier of the Confluence space that the attachment is part of.

SQL name

status

Data type

String

Updated at

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

SQL name

updated_at

Data type

Datetime

Updated by

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

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 attachment.

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.

Attachment label

The confluence_attachment_label table lists the labels added to each attachment.

The table uses the following columns:

Attachment ID

The unique identifier of the attachment that the label was added to.

SQL name

attachment_id

Data type

String

Foreign key

Links to a record in the confluence_attachment table.

Name*

The name of the label.

SQL name

name

Data type

String

Namespace*

The namespace of the label, which helps determine its visibility.

SQL name

namespace

Data type

String

Example values

  • global = label is visible to anyone who can see the labeled attachment

  • my = personal label that’s only visible to the owner

  • system = label is set and removed by the system, and is not shown in the UI

  • team = label is associated with a team

Owned by

The unique identifier of the person who added the label to the attachment.

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

 

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.

Attachment property

The confluence_attachment_property table lists the properties associated with each attachment. These properties are set via third-party apps.

The table uses the following columns:

Attachment ID

The unique identifier of the attachment.

SQL name

attachment_id

Data type

String

Foreign key

Links to a record in the confluence_attachment table.

Key*

The key of the attachment property.

SQL name

key

Data type

String

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 attachment 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.


Table for comment data

Comment

The confluence_comment table lists all comments made on pages, blog posts, and attachments.

The table 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.

Extensions

List of extensions present in the comment.

SQL name

extensions

Data type

Array of strings

List of hyperlinks present in the comment.

SQL name

links

Data type

Array of strings

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 title*

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

SQL name

parent_title

Data type

String

Parent attachment ID

The unique identifier of the parent attachment of the comment.

The comment can have zero or one parent attachment.

SQL name

parent_attachment_id

Data type

String

Foreign key

Links to a record in the confluence_attachment table.

Parent comment ID

The unique identifier of the parent comment of the comment.

The comment can have zero or one parent comment.

SQL name

parent_comment_id

Data type

String

Foreign key

Links to a record in the confluence_comment table.

Parent database ID

The unique identifier of the parent database of the comment.

SQL name

parent_database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Parent page ID

The unique identifier of the parent page or blog post of the comment.

SQL name

parent_page_id

Data type

String

Foreign key

Links to a record in the confluence_page table.

Parent whiteboard ID

The unique identifier of the parent whiteboard of the comment.

SQL name

parent_whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard table.

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 content summary data

Each content type in Confluence has its own summary table. However, the data for pages and blog posts are combined into a single “Page” table, and you can use the “Type” column within that table to filter for a particular content type.

Database

The confluence_database table lists your databases.

The table uses the following columns:

Created at

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

SQL name

created_at

Data type

Datetime

Created by

The unique identifier of the person who created the database.

SQL name

created_by

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Icon URL*

The URL of the icon for the database.

SQL name

icon_url

Data type

String

Language*

The language that the database is displayed in.

SQL name

language

Data type

String

Parent database ID

The unique identifier of the parent database in the content hierarchy.

SQL name

parent_database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Parent page ID

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

SQL name

parent_page_id

Data type

String

Foreign key

Links to a record in the confluence_page table.

Parent whiteboard ID

The unique identifier of the parent whiteboard in the content hierarchy.

SQL name

parent_whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard table.

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 database.

SQL name

space_id

Data type

String

Foreign key

Links to a record in the confluence_space table.

Status*

The current status of the database.

SQL name

status

Data type

String

Example values

  • archived

  • current

  • draft

  • trash

  • historical

Title*

The title of the database.

SQL name

title

Data type

String

Updated at

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

SQL name

updated_at

Data type

Datetime

URL*

The URL of the database.

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

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.

Extensions

Lists of extensions present in the body of the page or blog post.

SQL name

extensions

Data type

Array of strings

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

Links

List of hyperlinks present in the body of the page or blog post.

SQL name

links

Data type

Array of strings

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.

Whiteboard

The confluence_whiteboard table lists your whiteboards.

The table uses the following columns:

Created at

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

SQL name

created_at

Data type

Datetime

Created by

The unique identifier of the person who created the whiteboard.

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 whiteboard.

SQL name

icon_url

Data type

String

Language*

The language that the whiteboard is displayed in.

SQL name

language

Data type

String

Parent database ID

The unique identifier of the parent database in the content hierarchy.

SQL name

parent_database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Parent page ID

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

SQL name

parent_page_id

Data type

String

Foreign key

Links to a record in the confluence_page table.

Parent whiteboard ID

The unique identifier of the parent whiteboard in the content hierarchy.

SQL name

parent_whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard table.

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 whiteboard.

SQL name

space_id

Data type

String

Foreign key

Links to a record in the confluence_space table.

Status*

The current status of the whiteboard.

SQL name

status

Data type

String

Example values

  • archived

  • current

  • draft

  • trash

  • historical

Title*

The title of the whiteboard.

SQL name

title

Data type

String

Updated at

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

SQL name

updated_at

Data type

Datetime

URL*

The URL of the whiteboard.

SQL name

url

Data type

String

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_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.


Tables for content mapping data

Mapping data for each content type are aggregated into the following tables:

  • Content contributor mapping

  • Content favorited by mapping

  • Content updated by mapping

  • Content watcher mapping

To get data for a specific content type, use the corresponding foreign key in each table. For example, if you only wanted a list of people who have contributed to pages, you’d want to filter the “Content contributor mapping” table for only rows where the “Page ID” column is not null.

Content contributor mapping

The confluence_content_contributor_mapping table holds associations between each type of content (pages, blog posts, databases, and whiteboards) and all accounts that have contributed to them.

The table uses the following columns:

Account ID

The unique identifier of the person who contributed to the content.

SQL name

account_id

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

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

 

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.

Content favorited by mapping

The confluence_favorited_by_mapping table holds associations between each type of content (pages, blog posts, databases, and whiteboards) and all accounts that have favorited them.

The table uses the following columns:

Account ID

The unique identifier of the person who favorited the content.

SQL name

account_id

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

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

 

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.

Content updated by mapping

The confluence_content_updated_by_mapping table holds associations between each type of content (pages, blog posts, databases, or whiteboards) and all 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 content.

SQL name

account_id

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

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

 

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.

Content watcher mapping

The confluence_content_watcher_mapping table holds associations between each type of content (pages, blog posts, databases, or whiteboards) and all accounts that are watching them.

The table uses the following columns:

Account ID

The unique identifier of the person who watched the content.

SQL name

account_id

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

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

 

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.


Tables for content metadata

Metadata for each content type are aggregated into the following tables:

  • Content label

  • Content property

  • Content restriction

Content label

The confluence_content_label table lists the labels added to each page, blog post, database, or whiteboard.

The table uses the following columns:

Database ID

The unique identifier of the database associated with the label.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Name*

The name of the label.

SQL name

name

Data type

String

Namespace*

The namespace of the label, which helps determine its visibility.

SQL name

namespace

Data type

String

Example values

  • global = label is visible to anyone who can see the labeled attachment

  • my = personal label that’s only visible to the owner

  • system = label is set and removed by the system, and is not shown in the UI

  • team = label is associated with a team

Owned by

The unique identifier of the person who added the label to the content.

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 associated with the label.

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

 

Whiteboard ID

The unique identifier of the whiteboard associated with the label.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.

Content property

The confluence_content_property table lists the properties associated with each page, blog post, database, or whiteboard.

The table uses the following columns:

Database ID

The unique identifier of the database associated with the property.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

Key*

The key of the property.

SQL name

body

Data type

String

Page ID

The unique identifier of the page or blog post associated with the property.

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

Whiteboard ID

The unique identifier of the whiteboard associated with the property.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.

Content restriction

The confluence_content_restriction table lists the restrictions, which can be applied to an individual account or group, configured for each page, blog post, database, or whiteboard.

The table uses the following columns:

Authorized account

The unique identifier of the person who is authorized to access the content.

SQL name

authorized_account

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Authorized group*

The unique identifier of the group who is authorized to access the content.

SQL name

authorized_group

Data type

String

Foreign key

Links to a record in the atlassian_group table in the schema for organization data.

Database ID

The unique identifier of the database.

SQL name

database_id

Data type

String

Foreign key

Links to a record in the confluence_database table.

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 that’s been applied to the account or group.

SQL name

restriction_type

Data type

String

Example values

view, edit

Row refreshed at

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

SQL name

row_refreshed_at

Data type

Datetime

 

Whiteboard ID

The unique identifier of the whiteboard.

SQL name

whiteboard_id

Data type

String

Foreign key

Links to a record in the confluence_whiteboard 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.


Tables for space data

There are several tables for space data:

  • Space

  • Space label

  • Space permission mapping

  • 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 permission mapping

The confluence_space_permission_mapping table holds associations between spaces and the accounts with permission to access them.

The table uses the following columns:

Authorized account

The unique identifier of the person who is authorized to access the space.

SQL name

authorized_account

Data type

String

Foreign key

Links to a record in the account table in the schema for organization data.

Authorized group

The unique identifier of the group who is authorized to access the space.

SQL name

authorized_group

Data type

String

Foreign key

Links to a record in the atlassian_group table in the schema for organization data.

Permission type

The type of permission that the account or group has to the space.

SQL name

permission_type

Data type

String

Example values

space-admin, anonymous

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.


Tables for page and blog post data

These tables will be deprecated and removed from the schema. Use the tables prepended with Content in the names instead.

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

  • 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 contributor mapping

This table will be deprecated and removed from the schema. Use the Content contributor mapping table instead.

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

This table will be deprecated and removed from the schema. Use the Content favorited by mapping table instead.

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

This table will be deprecated and removed from the schema. Use the Content label table instead.

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

This table will be deprecated and removed from the schema. Use the Content property table instead.

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

This table will be deprecated and removed from the schema. Use the Content restriction table instead.

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

This table will be deprecated and removed from the schema. Use the Content updated by mapping table instead.

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

This table will be deprecated and removed from the schema. Use the Content watcher mapping table instead.

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.

Still need help?

The Atlassian Community is here for you.