Question

Your finance team wants detailed, near-real-time billing data (including labels and per-SKU usage) available for SQL analysis. As the project owner with the required billing permissions, what is the correct way to make this data continuously available?

Accepted Answer

In Billing > Billing export, enable Detailed usage cost export and select a BigQuery dataset as the destination

Answer

Manually download the monthly CSV invoice from the billing console and upload it to a Cloud Storage bucket each month

Answer

Create a Cloud Monitoring dashboard that charts the billing account's spend metrics for the finance team

Answer

Run 'gcloud billing accounts list' on a daily schedule and pipe the output into a BigQuery table