execute_sql_query
Run SQL queries against Rockfish datasets and return results in CSV format. Use quoted dataset IDs as table names and backticked column names to retrieve filtered data.
Instructions
Execute a SQL query against Rockfish datasets and return results in CSV format
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| query | Yes | The SQL query to execute. REQUIRED SQL SYNTAX: Use dataset ID wrapped in double quotes as table name (e.g., "rWBroVVFla7I0Fv9nBZXh") and wrap column names in backticks (e.g., `column_name`). Example: SELECT `timestamp`, `value` FROM "rWBroVVFla7I0Fv9nBZXh" WHERE `status` = 'active' | |
| project_id | No | Optional project ID to execute the query in |