FOCUS column explorer

Combine them: a 6-step checklist

1. Pick one FOCUS versionUse the highest version every provider offers, and keep all exports on it.
2. Keep history in the same formatBackfill past months with the same export, not a mix of native and FOCUS files.
3. Load everything into one tableParquet, CSV and BigQuery all land in the same column names.
4. Union, do not joinStack the rows. ProviderName tells you which cloud each row came from.
5. Leave x_ columns as extrasColumns starting with x_ are provider extensions: useful, but not comparable across clouds.
6. Agree on tag keysFOCUS gives one Tags column, not one spelling. "CostCenter" vs "cost-center" is still your job.

SELECT ProviderName,
       ServiceCategory,
       SUM(BilledCost)    AS billed_cost,
       SUM(EffectiveCost) AS effective_cost
FROM (
  SELECT * FROM focus_aws
  UNION ALL SELECT * FROM focus_azure
  UNION ALL SELECT * FROM focus_gcp
) AS focus_all
WHERE BillingPeriodStart = DATE '2026-10-01'
GROUP BY ProviderName, ServiceCategory
ORDER BY effective_cost DESC;

Select the FOCUS columns by name in each SELECT if your exports carry different x_ extension columns.