After entering a SQL query (plus, optionally, a R script) in the editor, click on "Run" button, or press Cmd + Enter / Ctrl + Enter to run the query.
Useful: If you need to quickly run a subset of your query, e.g. a sub-select or a query without a WHERE clause, just select the part of the query you want to run and hit Cmd + Enter / Ctlr + Enter - the selected portion of the query will be executed instead of the whole text entered.
The query will be executed against the selected datasource. The results area will display the resulting data in case the execution is successful, or the query (or connectivity) error in case the execution resulted in an error.
When running a query we automatically apply (or modify) LIMIT statement to avoid running queries that produce too many rows of output. The maximum number of rows is limited to 5.000 rows (10.000 rows for business plan)
Please get in touch with Support via a ticket or email to firstname.lastname@example.org in case you would need to have these limits raised.
Hint: You can run several queries at once, which is very useful for instance if you need to create a TEMP table as part of complex query. The result of the query execution will be the result of the last query.