Stay organized with collectionsSave and categorize content based on your preferences.
CAPACITY_COMMITMENTS view
TheINFORMATION_SCHEMA.CAPACITY_COMMITMENTSview contains a near real-time
list of all current capacity commitments within the administration project. Each
row represents a single, current capacity commitment. A current capacity
commitment is either pending or active and has not been deleted. For more
information about reservation, seeSlot commitments.
Required permission
To query theINFORMATION_SCHEMA.CAPACITY_COMMITMENTSview,
you need thebigquery.capacityCommitments.listIdentity and Access Management (IAM)
permission for the project.
Each of the following predefined IAM roles includes the required
permission:
Whether the commitment is associated with the legacy flat-rate capacity model or an edition. IfFALSE, the current commitment is associated with an edition. IfTRUE, the commitment is the legacy flat-rate capacity model.
renewal_plan
STRING
New commitment plan after the end of current commitment plan. You can change the renewal plan for a commitment at any time until it expires.
Scope and syntax
Queries against this view must include aregion qualifier.
If you do not specify a regional qualifier, metadata is retrieved from all
regions. The following table explains the region scope for this view:
[[["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\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.CAPACITY_COMMITMENTS\u003c/code\u003e view provides a real-time list of all current, pending, or active capacity commitments within a specified administration project.\u003c/p\u003e\n"],["\u003cp\u003eQuerying this view requires \u003ccode\u003ebigquery.capacityCommitments.list\u003c/code\u003e IAM permission, which is included in several predefined roles like \u003ccode\u003eroles/bigquery.resourceAdmin\u003c/code\u003e and \u003ccode\u003eroles/bigquery.user\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view represents a single capacity commitment, including details such as its ID, commitment plan, current state (\u003ccode\u003ePENDING\u003c/code\u003e or \u003ccode\u003eACTIVE\u003c/code\u003e), slot count, and associated edition.\u003c/p\u003e\n"],["\u003cp\u003eQueries against the \u003ccode\u003eINFORMATION_SCHEMA.CAPACITY_COMMITMENTS\u003c/code\u003e view must include a region qualifier specifying the dataset region, for example, \u003ccode\u003eregion-us\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eis_flat_rate\u003c/code\u003e column indicates whether the commitment is associated with the legacy flat-rate capacity model (\u003ccode\u003eTRUE\u003c/code\u003e) or an edition (\u003ccode\u003eFALSE\u003c/code\u003e).\u003c/p\u003e\n"]]],[],null,["# CAPACITY_COMMITMENTS view\n=========================\n\nThe `INFORMATION_SCHEMA.CAPACITY_COMMITMENTS` view contains a near real-time\nlist of all current capacity commitments within the administration project. Each\nrow represents a single, current capacity commitment. A current capacity\ncommitment is either pending or active and has not been deleted. For more\ninformation about reservation, see [Slot commitments](/bigquery/docs/reservations-workload-management#slot_commitments).\n\nRequired permission\n-------------------\n\nTo query the `INFORMATION_SCHEMA.CAPACITY_COMMITMENTS` view,\nyou need the `bigquery.capacityCommitments.list` Identity and Access Management (IAM)\npermission for the project.\nEach of the following predefined IAM roles includes the required\npermission:\n\n- `roles/bigquery.resourceAdmin`\n- `roles/bigquery.resourceEditor`\n- `roles/bigquery.resourceViewer`\n- `roles/bigquery.user`\n- `roles/bigquery.admin`\n\nFor more information about BigQuery permissions, see\n[Access control with IAM](/bigquery/docs/access-control)\n\nSchema\n------\n\nThe `INFORMATION_SCHEMA.CAPACITY_COMMITMENTS` view has the\nfollowing schema:\n\nScope and syntax\n----------------\n\nQueries against this view must include a [region qualifier](/bigquery/docs/information-schema-intro#syntax).\nIf you do not specify a regional qualifier, metadata is retrieved from all\nregions. The following table explains the region scope for this view:\n\nReplace the following:\n\n- Optional: \u003cvar translate=\"no\"\u003ePROJECT_ID\u003c/var\u003e: the ID of your Google Cloud project. If not specified, the default project is used.\n- \u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e: any [dataset region name](/bigquery/docs/locations). For example, ```region-us```.\n\n \u003cbr /\u003e\n\n \u003cbr /\u003e\n\n | **Note:** You must use [a region qualifier](/bigquery/docs/information-schema-intro#region_qualifier) to query `INFORMATION_SCHEMA` views. The location of the query execution must match the region of the `INFORMATION_SCHEMA` view.\n\n\u003cbr /\u003e\n\nExample\n-------\n\nThe following example returns a list of active capacity commitments for the\ncurrent project: \n\n```googlesql\nSELECT\n capacity_commitment_id,\n slot_count\nFROM\n `region-us`.INFORMATION_SCHEMA.CAPACITY_COMMITMENTS\nWHERE\n state = 'ACTIVE';\n```\n\nThe result is similar to the following: \n\n```\n+------------------------+------------+\n| capacity_commitment_id | slot_count |\n+------------------------+------------+\n| my_commitment_05 | 1000 |\n| my_commitment_06 | 1000 |\n| my_commitment_07 | 1500 |\n| my_commitment_08 | 2000 |\n+------------------------+------------+\n```"]]
