FOCUS SQL Lab

SQL on real FOCUS billing data, running in your browser Loading DuckDB…

Dataset

CostAndUsage points to

Loading…

Sources and cleaning

cau_real is anonymised real FOCUS 1.0 data (AWS, Microsoft, Oracle, a little Google) from the FinOps Foundation's FOCUS-Sample-Data. Costs are anonymised: read the method, not the money.
To let 1.5 queries run on it, every 1.5 column was added. Columns 1.0 doesn't have are NULL. ServiceProviderName and HostProviderName were derived from ProviderName, PublisherName and InvoiceIssuerName using the spec's migration guidance. The removed 1.0 columns are kept so you can practise migrating queries.
The sample writes missing values as the text NULL. These were loaded as real nulls.
cau_examples and the other tables come from the specification's worked-example CSVs. Each file is a separate scenario, so filter by x_ExampleFile before you add anything up. Some files used the text null or currency text such as $10,000.00 in Decimal columns. These were cleaned on load.
The spec's example queries were converted from BigQuery SQL to DuckDB SQL with sqlglot. ? placeholders were filled with values from the data.

⌘ / Ctrl + Enter