wdata_run_sql
Execute ad-hoc SQL queries on Wdata tables and return rows. Creates a temporary query, runs it, and downloads the CSV result.
Instructions
Execute one-off Wdata SQL and return rows.
Tables MUST be referenced by the sql_ref from wdata_list_tables — "databaseId"."tableId" AS "alias" — plain names do not resolve. The dialect is Trino. Mechanics: there is no ad-hoc SQL endpoint, so this creates a temporary saved query, runs it, downloads the CSV result, then deletes the temporary query.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sql | Yes | ||
| timeout | No | ||
| max_rows | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |