Using the SQL Editor

Opening or creating a new SQL file directs you to the SQL Editor page. The editor allows you to import datasets, use built-in functions and run real-time queries on the datasets.

The query can be run by pressing ‘Run file’ button at the top of the script. You also have the option to run individual statements by highlighting them and pressing ‘Run selected’. The query results will be displayed at the bottom of the page. Note that when fetching the data, the table name must be prefixed by public (see example below).

Using the buttons displayed in the top-right of the results output section, you can save the fetched output as a new custom view, save as a new file, or open data in the new tab.

Importing datasets

Instead of typing the name of the table, you can easily import a dataset into your SQL script by dragging a table of interest from the Data panel on the right and dropping it into the script.