Company
Date Published
Author
Katie Law
Word count
1430
Language
English
Hacker News points
None

Summary

Ternary, a FinOps platform for Google Cloud customers, addresses the challenge of managing large volumes of cost-related data by implementing a 3-query approach to enable multidimensional analysis and optimize cloud spending. This method involves three key steps: aggregating overall cost totals over a specific period, identifying the top N combinations of projects and categories with the highest spending, and using this data to generate detailed breakdowns while accounting for the remaining data in an "other" column. This approach ensures that users receive a comprehensive view of their expenses without exceeding data limits, improving data visualization and decision-making capabilities. While this method increases the number of queries and potential costs, especially when using on-demand pricing for data queries, it provides a more complete depiction of user data, balancing performance with the cost of implementation.