This will create a feature request which anybody can view and comment on.
Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.
What you would like to accomplish: Run BigQuery queries on the billing export that filters the location.zone information for our compute engine custom instances
How this might work: The location.region (e.g.: us-east1) is populated in the billing export, however the location.zone field is empty. It would be useful for our reports to have this field populated as well (e.g.: 'us-east1-d').
If applicable, reasons why alternative solutions are not sufficient: We have thousands of instances and labeling them would be too laborious.
Other information (workarounds you have tried, documentation consulted, etc): Labeling the resources [1] of the respective instances at creation time or afterwards [2] mentioning its zone (e.g. Key = zone; Value = us-east1-d). The Cloud Asset Inventory [3] can be used to gather their Location. This documentation page [4] shows an example on how to query the billing export by labels after the implementation of the labeling system.
Description
Please describe your requested enhancement. Good feature requests will solve common problems or enable new use cases.
What you would like to accomplish: Run BigQuery queries on the billing export that filters the location.zone information for our compute engine custom instances
How this might work: The location.region (e.g.: us-east1) is populated in the billing export, however the location.zone field is empty. It would be useful for our reports to have this field populated as well (e.g.: 'us-east1-d').
If applicable, reasons why alternative solutions are not sufficient: We have thousands of instances and labeling them would be too laborious.
Other information (workarounds you have tried, documentation consulted, etc): Labeling the resources [1] of the respective instances at creation time or afterwards [2] mentioning its zone (e.g. Key = zone; Value = us-east1-d).
The Cloud Asset Inventory [3] can be used to gather their Location.
This documentation page [4] shows an example on how to query the billing export by labels after the implementation of the labeling system.
[1]
[2]
[3]
[4]