Uploaded image for project: 'Subscription Watch'
  1. Subscription Watch
  2. SWATCH-4485

Identifying Primary Record in Tally Snapshots for payg products

XMLWordPrintable

    • Icon: Task Task
    • Resolution: Done
    • Icon: Normal Normal
    • None
    • None
    • swatch-tally
    • 5
    • False
    • Hide

      None

      Show
      None
    • False
    • subs-swatch-thunder
    • Swatch Thunder Sprint 8

      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:

      1. Identify which of the 16 snapshots is the primary record for payg product.
      2. Write rules if there are any edge cases and document them for payg product
      3. 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
      4. 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.

              mstead@redhat.com Michael Stead
              karshah@redhat.com Kartik Shah
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated:
                Resolved: