Monitoring

Beta

This product is in a pre-release state and might change or have limited support. For more information, see the product launch stages.

Viewing project and reservation slot usage using INFORMATION_SCHEMA

Project and reservation usage information is available for querying with INFORMATION_SCHEMA job views. Reservation names are stored in the reservation_id field of the job views.

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:

• Audit logs, specifically slot-ms consumed
• Jobs API

Viewing your flat-rate bill

To view your flat-rate bill in real time:

1. In the Google Cloud Console, go to the Billing portal.
2. Navigate to the Reports section.

1. Optionally, set the following settings under filters:
   1. Group by SKU.
   2. Filter for "BigQuery".

Cloud Console displays your BigQuery flat-rate spend for each region and for each commitment type (annual and monthly):

Note: BigQuery flat-rate pricing is in calendar-months. Your bill doesn't change due to variability in month length. All else being equal, your rate remains the same month to month.

Audit logs

Creating, deleting, and updating resources related to BigQuery Reservations are recorded in the owner project's audit logs. See the BigQuery audit log section for more information.