xarray-sql
xarray-sql copied to clipboard
Demo: Automet
Let's demo this package with an automatic weather historian.
Brief summary of how: Embed a SQL-to-text LLM in the browser (or, likely an API). Let users ask questions that can be translated to SQL queries. Run these queries against ARCO-ERA5 via this package.
This lets users ask questions about the known history of the climate.
Candidate model: https://huggingface.co/defog/sqlcoder-7b-2
Better than ARCO-ERA5 would be EarthMover's temporal chunked ERA5 surface dataset for this demo.