🤖 [AI] Filed from findings raised in discussion #2068.
⚠️ Problem
FinOps hubs only supports the 2023-05-01 Microsoft Customer Agreement (MCA) price sheet export schema. Microsoft's current/default MCA price sheet schema is now 2024-08-01 (see price sheet schema reference and the schema index). An MCA customer exporting the current default price sheet version gets an export hubs doesn't correctly ingest, and had to manually select the older 2023-05-01 dataset version to get working reservation/savings-plan price data (see discussion #2068).
EA price sheet stays on 2023-05-01 (unchanged) — this only affects MCA.
🛠️ Solution
Add ingestion support for the 2024-08-01 MCA price sheet schema alongside the existing 2023-05-01 support. Schema diff between the two versions (per Microsoft Learn):
- Removed in 2024-08-01:
discount, includedQuantity
- Added in 2024-08-01:
productOrderName
Everything else is unchanged. Update the price sheet ingestion transform(s) to handle both versions, and check whether productOrderName should map to x_SkuOrderName (already used for EA reservation price lookups) for consistency.
Also add a non-blocking test that checks the CM schema-index page's latest listed price sheet versions against what hubs currently supports, so a future schema bump gets flagged in CI rather than discovered by a customer. This test should warn, not fail, the pipeline.
ℹ️ Additional context
Related: #2068 (discussion)
🤖 [AI] Filed from findings raised in discussion #2068.
FinOps hubs only supports the 2023-05-01 Microsoft Customer Agreement (MCA) price sheet export schema. Microsoft's current/default MCA price sheet schema is now 2024-08-01 (see price sheet schema reference and the schema index). An MCA customer exporting the current default price sheet version gets an export hubs doesn't correctly ingest, and had to manually select the older 2023-05-01 dataset version to get working reservation/savings-plan price data (see discussion #2068).
EA price sheet stays on 2023-05-01 (unchanged) — this only affects MCA.
🛠️ Solution
Add ingestion support for the 2024-08-01 MCA price sheet schema alongside the existing 2023-05-01 support. Schema diff between the two versions (per Microsoft Learn):
discount,includedQuantityproductOrderNameEverything else is unchanged. Update the price sheet ingestion transform(s) to handle both versions, and check whether
productOrderNameshould map tox_SkuOrderName(already used for EA reservation price lookups) for consistency.Also add a non-blocking test that checks the CM schema-index page's latest listed price sheet versions against what hubs currently supports, so a future schema bump gets flagged in CI rather than discovered by a customer. This test should warn, not fail, the pipeline.
ℹ️ Additional context
Related: #2068 (discussion)