download_resource
Download and cache a dataset resource locally in DuckDB for fast querying. Supports CSV, XLSX, JSON, and datastore-active resources.
Instructions
Download a dataset resource and cache it locally in DuckDB for fast querying.
Supports CSV, XLSX, JSON, and datastore-active resources. If already cached, returns staleness info so you can decide whether to refresh. Numeric columns stored as text are automatically cast to DOUBLE.
Workflow: search_datasets → get_dataset_info → download_resource → query_cached.
Args: resource_id: Prefixed resource ID (e.g. "toronto:abc123") or bare ID
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| resource_id | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |