Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tampilan CAPACITY_COMMITMENTS
Tampilan INFORMATION_SCHEMA.CAPACITY_COMMITMENTS berisi daftar semua komitmen kapasitas saat ini dalam project administrasi yang mendekati real-time. Setiap
baris mewakili satu komitmen kapasitas saat ini. Komitmen kapasitas saat ini tertunda atau aktif dan belum dihapus. Untuk mengetahui informasi selengkapnya tentang reservasi, lihat Komitmen slot.
Izin yang diperlukan
Untuk membuat kueri tampilan INFORMATION_SCHEMA.CAPACITY_COMMITMENTS, Anda memerlukan
izin Identity and Access Management (IAM) bigquery.capacityCommitments.list untuk
project tersebut.
Setiap peran IAM yang telah ditetapkan berikut menyertakan izin
yang diperlukan:
Tabel virtual INFORMATION_SCHEMA.CAPACITY_COMMITMENTS memiliki skema berikut:
Nama kolom
Jenis data
Nilai
ddl
STRING
Pernyataan DDL yang digunakan untuk membuat komitmen kapasitas ini.
project_id
STRING
ID project administrasi.
project_number
INTEGER
Jumlah project administrasi.
capacity_commitment_id
STRING
ID yang secara unik mengidentifikasi komitmen kapasitas.
commitment_plan
STRING
Paket komitmen dari komitmen kapasitas.
state
STRING
Nyatakan komitmen kapasitas. Dapat berupa PENDING atau
ACTIVE.
slot_count
INTEGER
Jumlah slot yang terkait dengan komitmen kapasitas.
edition
STRING
Edisi yang terkait dengan reservasi ini. Untuk informasi selengkapnya tentang edisi, lihat Pengantar edisi BigQuery.
is_flat_rate
BOOL
Apakah komitmen dikaitkan dengan model kapasitas tarif tetap lama atau edisi. Jika FALSE, komitmen saat ini dikaitkan dengan edisi. Jika TRUE, komitmen adalah model kapasitas tarif tetap lama.
renewal_plan
STRING
Paket komitmen baru setelah paket komitmen saat ini berakhir. Anda dapat mengubah paket perpanjangan komitmen kapan saja hingga masa berlakunya habis.
Cakupan dan sintaksis
Kueri terhadap tabel virtual ini harus menyertakan penentu region.
Jika Anda tidak menentukan penentu regional, metadata akan diambil dari semua region. Tabel berikut menjelaskan cakupan region untuk tabel virtual ini:
[[["Mudah dipahami","easyToUnderstand","thumb-up"],["Memecahkan masalah saya","solvedMyProblem","thumb-up"],["Lainnya","otherUp","thumb-up"]],[["Sulit dipahami","hardToUnderstand","thumb-down"],["Informasi atau kode contoh salah","incorrectInformationOrSampleCode","thumb-down"],["Informasi/contoh yang saya butuhkan tidak ada","missingTheInformationSamplesINeed","thumb-down"],["Masalah terjemahan","translationIssue","thumb-down"],["Lainnya","otherDown","thumb-down"]],["Terakhir diperbarui pada 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```"]]
