Overview

In addition to various analysis models, SolarEngine also supports users to query data in CLickhouse through SQL statements. This function enables more complicated query requirements.

Entry

Select "Analysis" in the top navigation menu to access the "Self-help SQL Query" page. When accessing the page for the first time, you may need to wait for 1-3 minutes for the system to initialize your data before performing queries.

Usage Guide

Currently, you can query the event table (d_events) and user table (d_users). You can check the table structure on the left side of the page.

In the SQL writing area, enter the SQL, and click the "Query" button. The query may take some time, so please be patient. After the query is complete, the data will be displayed below.

When you need to save a written SQL statement, you can click the "Save as" button in the top right corner of the editing area to save it to your personal account, for the next time you can quickly select from the saved SQL statements.

In the "Query History" section, you can view the history of executed statements.

If you need to query SQL syntax, you can refer to the official documentation of Clickhouse for more information.