After entering a SQL query (plus, optionally, an R script) in the editor, click on the "Run" button or press Cmd + Enter / Ctrl + Enter to run the query. The query will be executed against the selected data source. The results view will display the data in case the execution is successful, or a query (or connectivity) error in case the execution failed.
When running a query we automatically limit the maximum number of result rows to avoid running queries that are prohibitively expensive. To that end, the maximum number of rows in a query result is capped at 5.000 (10.000 for the 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. Analytical queries should be crafted such that major aggregations and thus narrowing of the result set is performed as part of the SQL query.
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. Some 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 a complex query. The result of the query execution will be the result of the last query.
- If you need to quickly run a small part 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.