Saved Queries
Ad-hoc analysis that anyone can re-run. Only SELECT and WITH are allowed, one statement at a time, capped and timed out — and every run is logged, including the ones that were refused.
Where to find it
Address in the console: /platform/queries
List · 8 columns · 8 fields on its form · 3 of them required · 2 actions
What the list shows
These are the columns of the list, in the order they are drawn. Any of them can be sorted on, filtered on, hidden, or exported.
| Column | Kind | Field name |
|---|---|---|
| Query | Code | code |
| Name | Text | name |
| Dataset | Code | dataset_code |
| Row limit | Number | row_limit |
| Runs | Number | run_count |
| Avg ms | Number | avg_duration_ms |
| Last run | Date and time | last_run_at |
| Shared | Yes or no | is_shared |
The form
What is asked for when a record is created here. Required fields are marked; a choice drawn from a configuration list is one an administrator can extend without a release.
| Field | Type | Choices | Notes |
|---|---|---|---|
| Query code required | Text | ||
| Name required | Text | ||
| Description | Long text | ||
| Dataset | Choice | Looked up from existing records | |
| SQL required | Long text | ||
| Row limit | Number | ||
| Owner | Choice | Looked up from existing records | |
| Shared | Yes or no |
What you can do here
Run SQL
Run a read-only query
Asks for: SQL* Row limit
Run primary
Run this query
* required
The rules that apply here
Everything on this screen obeys the platform rules rather than rules of its own. The ones worth knowing before you use it:
- Narrowing a list — search, conditions, sort, totals, export and saved views.
- What may be changed — the five grounds a record may not be edited on.
- Companies and business units — what the switcher above this list is doing to it.
- Creating a record — required fields, where choices come from, and how the number is allocated.
- Importing a spreadsheet — this screen accepts one, and it runs through the same rules as typing.