There are two tools you can use to create queries, the query builder and SQL. SQL should be used for more complex use cases. If you experience any limitations with the preview or downloading your data, consider the export or schedule export options.
This table presents the different actions and their limitations:
| Action | Limitation |
|---|---|
| UI Preview |
Timeout: 3 Min Returned Rows: 5,000 |
| Download | Returned Rows: 25,000 |
| Export to |
File Formats: PARQUET, ORC, CSV, and CSV Friendly Formatting CSV Friendly Formatting is limited to 2.3M rows in the results. |
| Scheduled Export |
File Formats: PARQUET, ORC, CSV, and CSV Friendly Formatting CSV Friendly Formatting is limited to 2.3M rows in the results. |