Query Editor limits and error messages
This page lists the fixed limits of Query Editor and the messages you may see, with what to do next.
Limits
| Item | Limit |
|---|---|
| Open query tabs | 10 |
| Rows shown in the result grid | First 10,000 rows |
| Rows in a downloaded file | 100,000 rows |
| Download formats | CSV, JSON |
| Maximum query run time | 48 hours, then the query stops |
| Saved query name | 1 to 255 characters, unique among your saved queries |
| Saved query description | Up to 1,000 characters |
| Saved query SQL size | Up to 10 MiB |
Access messages
| Message | What it means | What to do |
|---|---|---|
You don't have permission to access Query Editor. | Your role allows neither running nor saving queries. | Ask your Admin to assign a suitable role in Access management. |
You do not have permission to run queries. | Your role can save queries but not run them. | Ask your Admin to update your role in Access management. |
You don't have permission to save queries. | Your role can run queries but not save them. Save is disabled. | Ask your Admin to update your role in Access management. |
You do not have permission to access this data. | You have no access to a table or column in the query. | Ask your Admin to grant access in Data Security. |
Your session has expired. Please sign in again. | Your login session ended. | Sign in again. Your open tabs stay in the browser. |
Query messages
| Message | What it means | What to do |
|---|---|---|
Enter a SQL query to run. | The tab is empty or holds only comments. | Type a SQL statement, then run it. |
Syntax error at line {line}, column {column}. | The SQL is not valid at that position. | Fix the SQL on the line marked with a red icon. |
Query engine is unavailable. Please try again later. | Lakehouse cannot run queries right now. | Wait a few minutes and run the query again. If it persists, contact support. |
Showing first 10,000 rows. Download to get full results. | The result has more rows than the grid shows. | Download the result to get up to 100,000 rows. |
Query cancelled. | The query was stopped. | Run it again when needed. |
Unable to cancel query. | The cancel request did not succeed. | Check the status in the result panel. Select Cancel again if the query still runs. |
Query result is no longer available. Please run the query again. | The result can no longer be downloaded. | Run the query again, then download. |
Editor messages
| Message | What it means | What to do |
|---|---|---|
Autocomplete is unavailable. | Suggestions cannot load right now. | Keep typing. You can still run the query. |
Unable to format SQL. | The SQL cannot be read, so it was not formatted. | Fix the syntax, then format again. |
Maximum 10 tabs allowed. | You already have 10 tabs open. | Close a tab, then open a new one. |
Saved query messages
| Message | What it means | What to do |
|---|---|---|
Query name is required. | The Query name field is empty. | Type a name. |
A saved query with this name already exists. Please choose a different name. | You already have a saved query with this name. | Type another name, or open the existing query and overwrite it. |
Enter a SQL query to save. | The tab has no SQL. | Type SQL before you save. |
Saved query must not exceed 10 MiB. | The SQL is too large to save. | Shorten the SQL or split it into several queries. |
Description must not exceed 1,000 characters. | The description is too long. | Shorten the description. |
Query not found or already deleted. | The saved query no longer exists. | Select Save to store the SQL as a new query. |