r.2024.06.21.0

Summary:

Improvements to Trino migrations, a new data transfer direction column added to Trino tables for GCP and AWS, and a new queue to better distribute processing tasks.

What's Changed

• [COST-5141] Add command to remove expired hive partitions by @myersCody in #5166
• Update GitHub actions by @samdoran in #5165
• [COST-5141] Add group by to the outer query by @myersCody in #5170
• [COST-5141] Fix management command to use continue instead of return. by @myersCody in #5173
• [COST-5128] Process new subs tag to identify non-converted instances by @cgoodfred in #5162
• [COST-4745] Add data_transfer_direction to GCP network costs to Trino tables by @samdoran in #5130
• [COST-4741] Add data_transfer_direction for AWS network costs to Trino tables by @samdoran in #5129
• [COST-5168] - Adding new penalty pipeline by @lcouzens in #5176
• Improve our logging readability by @lcouzens in #5178
• add prometheus metrics for new queues by @lcouzens in #5179

Full Changelog: r.2024.06.17.0...r.2024.06.21.0

r.2024.06.17.0

Summary:

One new enhancement to enable saving plan costs for OCP on AWS calculations. Other minor bug fixes and enhancements detailed beow.

What's Changed

• Bump the pip group across 1 directory with 2 updates by @dependabot in #5161
• COST-5072 Check schema exists prior to querying it during HCS processing by @cgoodfred in #5137
• COST-5097 Format OCP data transfer fields like other usage fileds by @samdoran in #5152
• Remove suffix from masu trino endpoint by @myersCody in #5154
• catch None object by @maskarb in #5138
• COST-4966 Enable Savings plan costs for OCP on AWS calculations
• masu - Account for intermediate None values when getting cost model by @samdoran in #5167
• Update disable_source to work for tasks already in the download queue. by @myersCody in #5168

Full Changelog: r.2024.06.11.0...r.2024.06.17.0

r.2024.06.11.0

Summary:

Work around an issue in Azure with V2 cost exports by specifying the API version in the client.
Disable use of a new column in Trino tables due to incomplete data migrations. This will be reenabled once the Trino migrations complete successfully.

What's Changed

• Use newer API version for Azure Cost Management client by @samdoran, @lcouzens in #5158
• COST-5124 Pause use of csi_volume_handle in SQL by @myersCody in #5160

Full Changelog: r.2024.06.10.0...r.2024.06.11.0

r.2024.06.10.0

Summary:

Costs associated with ingress and egress network traffic for individual Azure nodes are now broken out separately. A new project, Network unattributed, shows costs related to node network traffic. These network costs can be distributed using a cost model in the same way as Platform and Worker unallocated costs. By default, Network unattributed costs are distributed, so existing project costs will not change.

This feature will be available for GCP and AWS in future releases.

Details on Network unattributed costs for OCP on Cloud

Previously the networking cost of the node was distributed amongst the projects on the node. Now those networking costs are removed into a separate NEW project called Network unattributed.

Example with numbers and cost model that does not distribute node network costs:

• I have a node called compute_1 and this node has 2 projects, projectA and projectB that each use 50% of the cluster leaving 0 unallocated costs.
• When I look at the costs for this node grouped by project today, projectA costs $15 and projectB costs $5 for a total of $20.
• Of that $20, I know that $5 is networking costs.
• After this change there will be 3 projects with costs for this node, projectA, projectB, and Network unattributed.
• The cost for projectA would now be $12.5, projectB would now be $2.5 and Network unattributed would be $5.
• The new Network unattributed project is the networking costs that can be specifically tied to this node but not broken down at the project level.

What's Changed

• Fix make load-test-customer-data by @maskarb in #5131
• COST-5035 Fix ocp on gcp tag matching SQL by @lcouzens in #5111
• COST-4744 Separate OCP on Azure network costs into a Network unattributed project by @cgoodfred in #5056
• COST-4962 Populate OCP Network UI Summary Tables during summary flow by @cgoodfred in #5057
• COST-4993 Unleash function to check "EC2 Individual VM Compute" feature flag by @bacciotti in #5091
• COST-4749 Add ability to distribute unattributed network cost by @cgoodfred in #5116
• COST-4906 Add CSI volume handle to hive OCP daily summary by @myersCody in #5124
• COST-5059 Reduce cadence of source status checks by @lcouzens in #5135
• COST-5023, COST-5065 Dependency update by @maskarb in #5139
• Update base image by @github-actions in #5133
• Update base image by @github-actions in #5140
• COST-4096 Migration to add volume handle to PVC topology by @myersCody in #5134
• COST-4906 Update resource matching to use CSI volume handle by @myersCody in #5132
• COST-4742 Add API for OCP on cloud network costs by @cgoodfred, @samdoran in #5088
• COST-5030 Removal of special case namespace tag matching (internal) by @lcouzens in #5142
• Update base image by @github-actions in #5141
• COST-5051 Prevent TABLE_NOT_FOUND error when looking up PVCs by @maskarb in #5120
• COST-5035 Fix OCP on GCP tag matching SQL by @lcouzens in #5144
• COST-4946 Add changes to populate AWSCostEntryLineItemSummaryByEC2Compute table by @djnakabaale in #5121
• Increase sources client resources in ephemeral by @lcouzens in #5151
• COST-5094 Data migration to default to distributing network and storage unattributed costs for existing cost models by @cgoodfred in #5145
• COST-5099 Add cost model calculation updates during OCP on Cloud processing flow by @lcouzens in #5150
• COST-5099 Change cost model update task to always run full month calculations by @lcouzens in #5149
• Update base image by @github-actions in #5156
• COST-5095 Default to distributing networking and storage unattributed if no cost model exists by @cgoodfred in #5146
• COST-5099 Don't break GCP cost models by @lcouzens in #5157

Full Changelog: r.2024.05.30.0...r.2024.06.10.0

r.2024.05.30.0

Summary:

• migrations for future features

What's Changed

• [COST-4930] Migration to drop unrequested fields from ec2-compute model by @djnakabaale in #5118
• Set locale in migration script by @bacciotti in #5126
• Add table exists check to trino migration management commands. by @myersCody in #5125
• [COST-4906] Update create table for Trino. by @myersCody in #5127
• [COST-4744] Add data_transfer_direction to create table SQL for OCP on Azure trino tables by @cgoodfred in #5128

Full Changelog: r.2024.05.23.0...r.2024.05.30.0

r.2024.05.23.0

Summary:

Some tag matching SQL fixes and model changes and migrations for AWSCostEntryLineItemSummaryByEC2Compute table.

What's Changed

• move gcp local create_daily_archives return outside for loop by @lcouzens in #5112
• [COST-5034] Fix ocp on azure tag matching SQL by @lcouzens in #5110
• [COST-5020] Use org_id as message key when producing swatch kafka messages by @cgoodfred in #5115
• [COST-4930] Migration to alter max_length for instance_name field by @djnakabaale in #5122
• [COST-4930] Increase max_length for instance_name field by @djnakabaale in #5123
• [COST-4930] Updates to AWSCostEntryLineItemSummaryByEC2Compute model by @djnakabaale in #5119

Full Changelog: r.2024.05.20.0...r.2024.05.23.0

r.2024.05.20.0

Summary:

Removed koku-cji, updated base image, and made various optimizations for GCP, Azure, and AWS components.

What's Changed

• delete koku-cji by @maskarb in #5107
• chore(image): update base image by @github-actions in #5101
• [COST-5024] Avoid custom JSON parsing for GCP credits field by @samdoran in #5103
• [COST-5015] Azure disk capacity table migration by @myersCody in #5090
• [COST-5015] Retrieve azure disk capacities by @myersCody in #5089
• [COST-5044] Revert AWS HCS CCSP Price Estimate by @cgoodfred in #5114

Full Changelog: r.2024.05.16.0...r.2024.05.20.0

r.2024.05.16.0

Summary:

GCP credits as JSON, distribution of unattributed storage costs, stricter tag matching, OS disk correlation limits, and OCP infra mapping start date override.

What's Changed

• [COST-5024] GCP Return credits field as json in bigquery. by @myersCody in #5100
• [COST-4913] Add ability to distribute unattributed storage cost. by @myersCody in #5102
• [COST-5030] - use stricter tag matching strategies by @lcouzens in #5105
• [COST-5011] Limit OS disk correlation to pod data source rows by @myersCody in #5106
• [COST-5029] - Override start date for OCP infra mapping by @lcouzens in #5108

Full Changelog: r.2024.05.13.0...r.2024.05.16.0

r.2024.05.13.0

Summary:

• Model changes in support of work for node network costs and itemized cloud instance costs
• Updated OCP on Azure correlation to include OS disks costs

What's Changed

• COST-4740 Migrations for OCP Cloud table network columns by @cgoodfred in #5086
• COST-4740 Model updates for OCP on Cloud project daily summary tables by @cgoodfred in #5087
• Add start/end date to "checking infra" logs by @maskarb in #5093
• COST-4930 Migration for AWSCostEntryLineItemSummaryByEC2Compute model by @djnakabaale in #5081
• COST-4930 Add AWS EC2 Compute summary table by @djnakabaale in #5069
• COST-4915 Add unattributed distribution to cost model form by @myersCody in #5072
• Update base image by @github-actions in #5097
• COST-3761 Generate example API data for several days by @samdoran in #5085
• COST-5011 Update correlation to include OS disks. by @myersCody in #5095
• COST-5028 Guard against report_status not existing by @maskarb in #5099

Full Changelog: r.2024.05.09.0...r.2024.05.13.0

r.2024.05.09.0

Summary:

Updated ClowdApp template so that Trino migration works correctly when run from a management command.

What's Changed

• Update base image by @github-actions in #5092
• COST-5007 Add Trino host/port to management CJI by @maskarb in #5094

Full Changelog: r.2024.05.08.0...r.2024.05.09.0