redash_query
Manage Redash queries: list, search, create, update, delete, run adhoc queries, and schedule or export results.
Instructions
Manage Redash queries. Actions: list, search, get, create, update, archive, delete, run, adhoc, export, schedule
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | ||
| id | No | Query ID (for get/update/archive/delete/run/export) | |
| q | No | Search term (for search) | |
| name | No | Query name (for create) | |
| query | No | SQL or MongoDB JSON query (for create/update/adhoc). For MongoDB, use JSON format e.g. {"collection": "my_col", "query": {"field": "value"}, "limit": 50, "sort": [{"name": "field", "direction": -1}]} | |
| data_source_id | No | Data source ID | |
| max_rows | No | Max rows to return for adhoc queries (default 200, prevents huge responses) | |
| page | No | ||
| page_size | No | Results per page (default 10, max 250) | |
| path | No | File path to export results (for export). Supports .csv and .json | |
| interval | No | Schedule interval in seconds (for schedule). e.g. 300=5min, 3600=1hr, 86400=daily | |
| until | No | Schedule end datetime ISO format (for schedule, optional) |