Skip to content

Add support for MCA price sheet schema version 2024-08-01 #2311

Description

🤖 [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)

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    Projects

    No projects

      Relationships

      None yet

      Development

      No branches or pull requests

      Issue actions