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 |
|
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 |
Links
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 |
|
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 |
|
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 |
|
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. |
Was this helpful?