Skip to content

[Hubs] Price ingestion creates extra rows #1736

Description

@flanakin

🐛 Problem

Price ingestion is adding more rows than are coming from Cost Management exports.

👣 Repro steps

  1. Set the raw ingestion to 1 or more days
  2. Drop all extents for the Prices_raw table to clear it, if there is data
  3. Ingest one month of data
  4. Compare the row count in Prices_raw and Prices_final_v1_0
Prices_raw | count // = 1,021,818

Prices_transform_v1_0 | count // = 1,264,006

🤔 Expected

Row counts should be the same

🙋‍♀️ Ask for the community

We could use your help:

  1. Please vote this issue up (👍) to prioritize it.
  2. Leave comments to help us solidify the vision.

Metadata

Metadata

Assignees

No one assigned

    Labels

    Skill: KQLKQL queries and Data Explorer integrationTool: FinOps hubsData pipeline solution

    Type

    Fields

    No fields configured for Bug.

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions