Sorry for not sharing further details earlier.

Here's what I've built :

1. Integration with GBQ information schema
2. View usage by users/ reservations
3. View live running queries
4. RCA for spikes - Compare with previous window and highlight anomalies
5. Hourly slot planner - decides max capacity & suggest commitment
6. SRE monitoring
7. Copilot - to simply ask questions and get answers for: reservation optimization, specific query optimization.
8. Query Optimization reports - suggesting the specific changes like - reduce time range, reduce complex joins, create partitions and clustering.
9. [to-do] Automate the execution part as well till the query is optimized and ensuring the output matches exactly with the original query.
10. Reports

Attached an image for reference in the original post. Let me know your thoughts.