Confluence Cloud Data Model
This section shows the available API objects and provides more information on executing SQL to Confluence APIs.
- The adapter models Confluence entities like pages, blogposts, comments, attachments, spaces, audit records and users as relational views, allowing you to write SQL to query Confluence data.
- Live connectivity to these objects means any changes to your Confluence account are immediately reflected when using the adapter.
Views describes the available views. Views are statically defined to model AuditRecords, Pages, Blogposts, Comments, Attachments, Contributors, Labels, Spaces and Users.
Collaborative Query Processing
The adapter offloads as much of the SELECT statement processing as possible to Confluence and then processes the rest of the query in memory. API limitations and requirements are also documented in this section.