Uploaded image for project: 'Cost Management'
  1. Cost Management
  2. COST-3813 AWS RHEL Metered Usage Pipeline to SWATCH
  3. COST-4328

Records without a vCPU present can be sent to SWATCH

XMLWordPrintable

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • Icon: Major Major
    • None
    • None
    • None
    • None
    • 1
    • False
    • None
    • False

      We are currently filtering out null vCPU records, we might need a small update to the filter there to prevent sending unimportant records. Trying with a real file to identify why the null filter did not filter them out correctly.

       

      The column type for product_vcpu in the aws_line_items table is a varchar so the null value is ''. Filter needs to be updated to filter out an empty string instead of `IS NOT NULL`. Relevant code location: https://github.com/project-koku/koku/blob/main/koku/subs/trino_sql/aws_subs_summary.sql#L53 

              cgoodfre Corey Goodfred (Inactive)
              cgoodfre Corey Goodfred (Inactive)
              Eva Šebestová Eva Šebestová
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

                Created:
                Updated:
                Resolved: