SQL queries

When a chart isn’t enough, ask the question directly: the SQL Query widget runs read-only SQL against your organization’s unified cost data — both clouds, plus findings, recommendations, alerts, and more.

Writing a query

1. In a custom view, add a SQL Query widget.
2. Write your query in the editor (autocomplete is available with Ctrl+Space).
3. Test & save with Ctrl+Enter.

A simple example — top services by spend over the last 30 days:

SELECT service_name, SUM(total_cost) AS cost
FROM daily_costs
WHERE date >= date('now','-30 day')
GROUP BY service_name
ORDER BY cost DESC
LIMIT 10;

Discovering the schema

The editor includes a built-in schema browser listing every available table and column with descriptions, and a set of example queries you can load with one click — month-over-month changes, unallocated spend, active recommendations by savings, and more. The schema browser in the product is always the authoritative, up-to-date reference.

Charting results

Query widgets can render results as a table, bar, line, or donut chart — the first text column becomes the label and the first numeric column the value. A query plus a chart mode makes a fully custom KPI in seconds.

Safety

Queries are read-only and run against your organization’s data only. They can’t modify anything, and they can’t see other tenants.