Skip to content
Asset 7

SQL queries

The core content of Connected Dreams / Origin consists of two parts:

  1. The database content. This holds all the structure information and all the text and other Directory and Document elements. The content is stored in a relational database (OLTP DB). Each tenant has their own backing logical database.
  2. File storage: This holds all uploaded attachments (e.g., PDFs and images).

Most of the database content is also streamed to a ClickHouse® database; each tenant has their own logical ClickHouse® database.

ClickHouse® is used because it suitable for the use case of dashboards (OLAP) and search.

Next to the (evolving) set of bundled dashboards, users can write their own SQL queries.

To perform a custom SQL query proceed as follows:

  1. Select an arbitrary node in the Directory browser using a Mouse Click
  2. Context Menu → ClickHouse SQL Data Browser

ClickHouse is a registered trademark of ClickHouse, Inc. https://clickhouse.com/

Limitations

Section titled “Limitations”

Users can only read the existing tables and they can only generate temporary tables. RAM and CPU usage are also restricted (restrictions depend on your subscription type).