Stay organized with collectionsSave and categorize content based on your preferences.
Monitor BigQuery reservations
As a BigQuery administrator, you can monitor reservations in your
project by viewing the project and reservation slot usage and also view
your capacity-based bill.
View project and reservation slot usage
You can view the project and reservation slot usage in the following ways:
INFORMATION_SCHEMAviews.To retrieve project and reservation usage
information, query theINFORMATION_SCHEMA.JOBS*views.
Thereservation_idfield
in theINFORMATION_SCHEMA.JOBS*views contains the reservation name.
Google Cloud console.The Google Cloud console includes charts that
display slot usage. For more information, seeUse administrative
resource charts.
Audit logs.Useaudit logsto
view metrics about slot usage.
TheJobsmethod.Use theJobsAPI methodto view metrics about slot usage for a job.
Cloud Monitoring.You can useCloud Monitoringto create dashboards to monitor your allocated slots. With a Cloud Monitoring dashboard, you can view your slot usage for each reservation and for each job type, across all projects within the reservation. For more information about the metrics available for the Cloud Monitoring dashboard, seeMetrics available for visualization.
View your capacity-based bill
To view your capacity-based bill in real time, follow these steps:
In the Google Cloud console, go to theBillingpage.
Select the billing account project for which you want to view the bill.
Navigate to theReportssection and then in theFilterssection, do
the following:
From theServiceslist, selectBigQueryand select all that's
applicable.
SelectAll SKUsfrom theSKUslist.
Reservation cost attribution
This feature lets you attribute reservation fees back to the specific query
usage across any projects that used the reservation. This results in more
accurate net costs for each project basis.
AllBigQuery Reservations APIcustomers have an"Analysis Slots Attribution"line item in their
Cloud Billing data. This line item is included on theBillingpage
and in the Cloud Billing export.
This line item shows slot hours used per project. It incurs no cost and doesn't
affect your invoice totals.
Audit logs
Creating, deleting, and updating resources related toBigQuery reservationsare
recorded in the project owner's audit logs.
For more information, seeAudit log.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-04 UTC."],[[["\u003cp\u003eBigQuery administrators can monitor project and reservation slot usage through \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e views, the Google Cloud console, audit logs, the \u003ccode\u003eJobs\u003c/code\u003e API method, and Cloud Monitoring.\u003c/p\u003e\n"],["\u003cp\u003eYou can view your real-time capacity-based bill in the Google Cloud console's Billing page by filtering for BigQuery services and SKUs.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery's "Analysis Slots Attribution" feature provides a breakdown of reserved slot usage across projects in Cloud Billing data without affecting invoice totals.\u003c/p\u003e\n"],["\u003cp\u003eAudit logs record the creation, deletion, and updates of BigQuery reservation resources, providing a detailed history of changes.\u003c/p\u003e\n"],["\u003cp\u003eThe amount of slots that are in use might appear to be higher than the reservation slot count due to how BigQuery provisions resources, however, users will not be charged for the slots that go beyond their reservation slot count.\u003c/p\u003e\n"]]],[],null,["# Monitor BigQuery reservations\n=============================\n\nAs a BigQuery administrator, you can monitor reservations in your\nproject by viewing the project and reservation slot usage and also view\nyour capacity-based bill.\n\nView project and reservation slot usage\n---------------------------------------\n\nYou can view the project and reservation slot usage in the following ways:\n\n- **`INFORMATION_SCHEMA` views.** To retrieve project and reservation usage\n information, query the [`INFORMATION_SCHEMA.JOBS*` views](/bigquery/docs/information-schema-jobs#examples).\n\n The [`reservation_id`](/bigquery/docs/information-schema-jobs#schema) field\n in the `INFORMATION_SCHEMA.JOBS*` views contains the reservation name.\n- **Google Cloud console.** The Google Cloud console includes charts that\n display slot usage. For more information, see [Use administrative\n resource charts](/bigquery/docs/admin-resource-charts).\n\n- **Audit logs.** Use [audit logs](/bigquery/docs/reference/auditlogs) to\n view metrics about slot usage.\n\n- **The `Jobs` method.** Use the [`Jobs` API method](/bigquery/docs/reference/rest/v2/jobs)\n to view metrics about slot usage for a job.\n\n- **Cloud Monitoring.** You can use [Cloud Monitoring](/bigquery/docs/monitoring-dashboard) to create dashboards to monitor your allocated slots. With a Cloud Monitoring dashboard, you can view your slot usage for each reservation and for each job type, across all projects within the reservation. For more information about the metrics available for the Cloud Monitoring dashboard, see [Metrics available for visualization](/bigquery/docs/monitoring-dashboard#metrics).\n\n| **Note:** The number of slots in use might appear higher than your reservation slot count because of how BigQuery provisions resources to reservations. You are not charged for slots beyond your reservation slot count.\n\nView your capacity-based bill\n-----------------------------\n\nTo view your capacity-based bill in real time, follow these steps:\n\n1. In the Google Cloud console, go to the **Billing** page.\n\n [Go to **Billing**](https://console.cloud.google.com/billing).\n2. Select the billing account project for which you want to view the bill.\n\n3. Navigate to the **Reports** section and then in the **Filters** section, do\n the following:\n\n 1. From the **Services** list, select **BigQuery** and select all that's applicable.\n 2. Select **All SKUs** from the **SKUs** list.\n\n| **Note:** BigQuery annual and three-year commitments are priced by months. Your bill doesn't change due to variability in the month length. If your slot usage remains unchanged, the rate remains the same every month.\n\nReservation cost attribution\n----------------------------\n\nThis feature lets you attribute reservation fees back to the specific query\nusage across any projects that used the reservation. This results in more\naccurate net costs for each project basis.\n\nAll [BigQuery Reservations API](/bigquery/docs/reservations-commitments#enabling-reservations-api)\ncustomers have an **\"Analysis Slots Attribution\"** line item in their\nCloud Billing data. This line item is included on the **Billing** page\nand in the Cloud Billing export.\n\nThis line item shows slot hours used per project. It incurs no cost and doesn't\naffect your invoice totals.\n\nAudit logs\n----------\n\nCreating, deleting, and updating resources related to\n[BigQuery reservations](/bigquery/docs/reservations-concepts) are\nrecorded in the project owner's audit logs.\nFor more information, see [Audit log](/bigquery/docs/reference/auditlogs#auditlog_format).\n\nWhat's next\n-----------\n\n- Learn about [capacity commitment plans](/bigquery/docs/reservations-workload-management#slot_commitments).\n- Learn how to [use administrative resource charts](/bigquery/docs/admin-resource-charts).\n- Learn about [BigQuery pricing](/bigquery/pricing)."]]
