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.
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 the query produces is limited to 5.000 rows (10.000 rows for business plan).
Note: The query results row limits apply to the size of the results, not to the number of rows in your tables. I.e. you can have millions of rows in your database, the query result row limit would only apply to the amount of rows the query can produce. In normal cases any queries that aggregate data would produce much less rows. In case of unaggregated queries, the limit may be hit.
Please get in touch with Support via a ticket or email to hi@cluvio.com in case you would need to have these limits raised.
Useful tips:
- 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.
- 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 / Ctrl + Enter - the selected portion of the query will be executed instead of the whole text entered.