Get started with Atlassian Analytics
Learn how to add Atlassian Analytics to a site and understand what you need to query data and create charts.
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.
The confluence_comment table lists all comments made on pages, blog posts, and attachments. It uses the following columns:
The body of the comment, stored in a JSON object.
SQL name | body |
---|---|
Data type | String |
The unique identifier of the comment. Use this as the primary key for comment data.
SQL name | comment_id |
---|---|
Data type | String |
The date and time (UTC time zone) when the comment was created.
SQL name | created_at |
---|---|
Data type | Datetime |
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. |
The title of the page, blog post, or attachment that the comment is on.
SQL name | parent_title |
---|---|
Data type | String |
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. |
The parent attachment of the comment.
The comment can have zero or one parent attachment.
SQL name | parent_attachment_id |
---|---|
Data type | String |
The parent comment of the comment.
The comment can have zero or one parent comment.
SQL name | parent_comment_id |
---|---|
Data type | String |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
The status of the comment.
SQL name | status |
---|---|
Data type | String |
Example values | draft, current, archived |
The date and time (UTC time zone) when the comment was last updated.
SQL name | updated_at |
---|---|
Data type | Datetime |
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. |
The URL of the comment.
SQL name | url |
---|---|
Data type | String |
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. |
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.
The confluence_page table lists your pages and blog posts.
The table uses the following columns:
The body content of the page or blog post, stored as a JSON object.
SQL name | body |
---|---|
Data type | String |
The date and time (UTC time zone) when the page or blog post was created.
SQL name | created_at |
---|---|
Data type | Datetime |
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. |
The URL of the icon for the page or blog post.
SQL name | icon_url |
---|---|
Data type | String |
The language that the page or blog post is displayed in.
SQL name | language |
---|---|
Data type | String |
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 |
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 |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
The current status of the page or blog post.
SQL name | status |
---|---|
Data type | String |
Example values | archived, current, draft, trash |
The title of the page or blog post.
SQL name | title |
---|---|
Data type | String |
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 |
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 |
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. |
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:
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. |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
The confluence_page_favorited_by_mapping table holds associations between pages/blog posts and accounts that have favorited them. It uses the following columns:
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. |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
The confluence_page_label table lists the labels associated with a page or blog post.
The table uses the following columns:
The name of the page or blog post label.
SQL name | name |
---|---|
Data type | String |
Helps determine the visibility of the label.
SQL name | namespace |
---|---|
Data type | String |
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. |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
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:
The key of the property.
SQL name | key |
---|---|
Data type | String |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
The value of the property.
SQL name | value |
---|---|
Data type | String |
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. |
The confluence_page_restriction table lists the restrictions that have been configured for each page or blog post.
The table uses the following columns:
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 |
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 |
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. |
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 |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
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:
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. |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
The confluence_page_watcher_mapping table holds associations between pages/blog posts and accounts that have watched them.
The table uses the following columns:
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. |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
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. |
There are several tables for space data:
Space
Space label
Space viewer mapping
The confluence_space table lists your spaces.
The table uses the following columns:
The date and time (UTC time zone) when the space was created.
SQL name | created_at |
---|---|
Data type | Datetime |
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. |
The description of the space.
SQL name | description |
---|---|
Data type | String |
The unique identifier of the homepage.
SQL name | homepage_id |
---|---|
Data type | String |
The URL of the page icon.
SQL name | icon_url |
---|---|
Data type | String |
The key of the space.
SQL name | key |
---|---|
Data type | String |
The name of the space.
SQL name | name |
---|---|
Data type | String |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
The unique identifier of the space.
SQL name | space_id |
---|---|
Data type | String |
The current status of the space.
SQL name | status |
---|---|
Data type | String |
Example values | archived, current |
The type of space.
SQL name | type |
---|---|
Data type | String |
Example values | personal, global |
The date and time (UTC time zone) when the space was last updated.
SQL name | updated_at |
---|---|
Data type | Datetime |
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. |
The URL of the space.
SQL name | url |
---|---|
Data type | String |
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. |
The confluence_space_label table lists the labels associated with a space.
The table uses the following columns:
The name of the space label.
SQL name | name |
---|---|
Data type | String |
Helps determine the visibility of the label.
SQL name | namespace |
---|---|
Data type | String |
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
The unique identifier of the space.
SQL name | space_id |
---|---|
Data type | String |
Foreign key | Links to a record in the confluence_space table. |
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. |
The confluence_space_viewer_mapping table holds associations between spaces and accounts that have viewed them.
The table uses the following columns:
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. |
The last refresh time (UTC time zone) for this record.
SQL name | row_refreshed_at |
---|---|
Data type | Datetime |
The unique identifier of the space.
SQL name | space_id |
---|---|
Data type | String |
Foreign key | Links to a record in the confluence_space table. |
The unique identifier of the team that can view the space.
SQL name | team_id |
---|---|
Data type | String |
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?