SQL Editor

Analyse your data using SQL queries

Next to the metric builder, you can also create your own custom SQL queries. If there are some types of analyses that Marple cannot cover in the metric builder, you can go all out and write it in SQL code!

You can find the SQL Editor in the Analysis section of Marple. It does require some knowledge of SQL in order to get the results you want.

Marple Custom SQL Editor

Write your query in the SQL Editor section. In order to execute the query to need to press the 'Run' button. The results will appear on the right in table form. You can choose to visualise the results in bar chart as well.

When making the query, make sure it is a valid SQL query (eg. use SELECT etc..) and make sure to include FROM data_table in the query. Marple will link this to the correct data set that you selected in the dropdown.

Signals need to be indicated with brackets ([signal_name]) in order to be parsed correctly. You can make use of the signal list below. Clicking on a signal will add it to the query automatically.

Example

In this query, we want to find the average speed of the car in every gear. I used GPT to generate this query. I can visualise the result in a bar chart.

The result makes sense, in higher gears we drive faster!

For more functionalities, you can check the Postgres documentation: https://www.postgresql.org/docs/