Warehouse · Read-only

Ask your warehouse

Non-technical staff type a question in plain English. The copilot writes the SQL, runs it against the operational warehouse and returns a short answer with the numbers behind it.

Answer

Brookhurst lost the most output to unplanned trips in July, at 0.61 GWh. Widnes was second at 0.42 GWh, driven by repeated EGT trips on E2.

Brookhurst0.61 GWh

Widnes0.42 GWh

Newton Green0.35 GWh

Calvert0.18 GWh

Generated SQL

SELECT site, SUM(lost_gwh) AS lost
FROM engine_events
WHERE event_type = 'unplanned_trip'
  AND month = '2026-07'
GROUP BY site
ORDER BY lost DESC
LIMIT 5;

The copilot only issues SELECT statements against a read-only warehouse role. Every query is logged and reviewable by the data team.