I am trying to find how much each resource is costing me in Google Cloud. When I run the query in BigQuery the data has no information about the resource like its name or id. For example I have a VM by the name of myvm with instance id of 1235XXXXX in myproject . How can I find the cost incurred on this vm in a given period. The vm has not labels set
The query I am running is
select *from myproject.mydynaset.gcp_billing_export_v1_786xxxxxxxx