In the Google Cloud billing information, the commitment_type column typically provides details about the type of commitment associated with a particular cost. However, it may not directly provide detailed breakdowns such as active commitment, utilized commitment, un-utilized commitment, commitment covered usage, spend based commitment covered usage, and eligible on-demand usage.
To obtain such detailed information, you would typically need to perform a more complex analysis of your billing data. This might involve:
-
Active Commitment: Identifying the periods during which a commitment is active based on the start and end dates of the commitment.
-
Utilized Commitment: Calculating the amount of committed resources that have been used during a given period.
-
Un-utilized Commitment: Determining the portion of committed resources that were not used during the commitment period.
-
Commitment Covered Usage: Assessing the usage that falls under the scope of the commitments.
-
Spend Based Commitment Covered Usage: Analyzing the spending associated with the usage covered by commitments.
-
Eligible On-Demand Usage: Identifying the usage that would have been eligible for on-demand pricing but was covered under a commitment.
This analysis typically requires combining data from multiple columns and possibly performing some custom calculations. The standard billing export to BigQuery includes detailed usage and cost data, but you may need to write custom SQL queries to extract and calculate the specific metrics you're interested in.
If you're not able to find this level of detail in the standard billing export, you might need to explore additional Google Cloud billing reports or tools, or consider reaching out to Google Cloud support for more detailed billing data and analysis capabilities.
LinkedIn
Twitter
