Viewing project and reservation slot usage using INFORMATION_SCHEMA
Viewing project and reservation slot usage in Cloud Monitoring
Information is available from the "Slots Allocated" metric in Cloud Monitoring. This metric information includes a per-reservation and per-job breakdown of slot usage. The information can also be visualized by using the custom charts metric explorer.
Additionally, you can monitor how your slots are consumed by using the following tools:
Viewing your flat-rate bill
To view your flat-rate bill in real time:
- In the Google Cloud Console, go to the Billing portal.
- Navigate to the Reports section.
- Optionally, set the following settings under filters:
- Group by SKU.
- Filter for "BigQuery".
Cloud Console displays your BigQuery flat-rate spend for each region and for each commitment type (annual and monthly):
Reservation cost attribution
Starting in May 2020, we will pilot a new feature that allows users to attribute reservation fees back to the specific query usage across any projects that utilized that reservation. This feature results in more accurate net costs on a per-project basis.
In preparation, all BigQuery Reservations API customers will see a new "Analysis Slots Attribution" line item in their Cloud Billing data. This includes both the Billing UI and the Billing Export. The cost for this new item is zero. These changes will not affect your invoice totals.
We will send out further communication about this feature soon.