microsoft / microsoft/finops-toolkit
[Hubs/KQL]: "Services" table has bad (duplicated) entries – evaluate cleaner solution
Nobody has claimed this yet.
- Dominant language
- PowerShell
- Stars
- 603
- Forks
- 248
- Avg merge
- 7d 11h
- Merged PRs (30d)
- 11
Description
Services table contains multiple entries for the same x_ResourceType
Resource types like microsoft.security/pricings appear multiple times in Services with different subcategories (Application Platforms, Containers, Security Posture Management, Virtual Machines), multiplying cost records 5x.
A first fix was implemented in PullRequest #1907.
Originally posted by @flanakin in https://github.com/microsoft/finops-toolkit/pull/1907#discussion_r2664446749
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reviewing PullRequest #1907 and the Services table logic around x_ResourceType. Compare the duplicated resource-type entries and their subcategories, then clarify a cleaner approach that prevents cost records from being multiplied. Done means the selected solution is implemented and the affected KQL results no longer contain duplicate resource-type-driven records.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- azure
- Domain
- data
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100