Question

Your finance team wants to build a chargeback report in BigQuery that combines resource usage costs with the current list prices for each SKU so they can model potential savings from committed use discounts. You have already enabled standard usage cost export to BigQuery. What additional configuration must you perform in the Cloud Billing console?

Accepted Answer

Enable the pricing data export to the same or another BigQuery dataset for the billing account

Answer

Enable detailed usage cost export, which automatically includes SKU list prices

Answer

Grant the finance team the Billing Account Viewer role so pricing appears in the usage export table

Answer

Create a Cloud Monitoring metric that scrapes SKU prices and writes them to BigQuery