-
Task
-
Resolution: Done
-
Normal
-
None
-
None
There are total of 198M records, determine and validate algorithm for identifying primary record in Tally Snapshots for each payg products.
- Each PAYG Products (e.g. rosa, rhel-els-payg-addon): Have 16 dimension combinations per snapshot due to varying (sla × usage × billing_provider × billing_account_id).
- Validate above point and check what permutations exists and how the data looks like for primary record.
- Check for edge cases like any of the value empty.
AC:
- Identify which of the 16 snapshots is the primary record for payg product.
- Write rules if there are any edge cases and document them for payg product
- Document queries for finding primary record and and any edge case in Design doc https://docs.google.com/document/d/1_lcBwWnR9upeX2V0QDp5Mx_yo_b1aZGlsjNjprbQD6E/edit?usp=sharing
- Add a summary to the document showing, per product, the number of records with _ANY values and the number of primary records without _ANY. This will help prioritize larger products when setting is_primary=true via the REST API.