-
Story
-
Resolution: Done
-
Normal
-
None
-
False
-
None
-
False
-
COST-2819 - Crawl: cost of running OpenShift
Update OCP daily summary SQL to add the cost category foreign key relationship
- We’ll want to add in a LEFT JOIN to the new category table for the pod and storage portions of the query here
- JOIN conditions will be where namespace like any(category namespace) or same for label
- https://github.com/project-koku/koku/blob/main/koku/masu/database/presto_sql/reporting_ocpusagelineitem_daily_summary.sql#L192