Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tampilan ORGANIZATION_OPTIONS_CHANGES
Anda dapat membuat kueri tampilan INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES untuk mengambil
metadata real-time tentang perubahan konfigurasi BigQuery dalam
organisasi.
Tampilan ini mencerminkan perubahan konfigurasi tingkat organisasi dan tingkat project yang dilakukan setelah 31 Januari 2024.
Izin yang diperlukan
Untuk mendapatkan izin yang diperlukan untuk mendapatkan perubahan konfigurasi, minta administrator untuk memberi Anda peran IAM BigQuery Admin (roles/bigquery.admin) di organisasi Anda.
Untuk mengetahui informasi selengkapnya tentang cara memberikan peran, lihat Mengelola akses ke project, folder, dan organisasi.
Peran bawaan ini berisi izin
bigquery.config.update
yang diperlukan untuk
mendapatkan perubahan konfigurasi.
Saat Anda membuat kueri tampilan INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES, hasil kueri akan berisi satu baris untuk setiap perubahan konfigurasi dalam organisasi.
Tampilan INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES memiliki skema berikut:
Nama kolom
Jenis data
Nilai
update_time
TIMESTAMP
Waktu saat perubahan konfigurasi terjadi.
username
STRING
Untuk pengguna pihak pertama, ini adalah email pengguna mereka. Untuk pengguna pihak ketiga, nama yang ditampilkan adalah nama yang ditetapkan pengguna di penyedia identitas pihak ketiga.
updated_options
JSON
Objek JSON opsi konfigurasi yang diupdate pengguna dalam
perubahan, yang berisi nilai sebelumnya dan nilai baru kolom yang diupdate.
project_id
STRING
Project ID. Kolom ini kosong untuk perubahan konfigurasi
tingkat organisasi.
project_number
INTEGER
Nomor project. Kolom ini kosong untuk perubahan konfigurasi
tingkat organisasi.
Retensi data
Tampilan ini berisi sesi yang sedang berjalan, dan histori sesi yang selesai dalam 180 hari terakhir.
Cakupan dan sintaksis
Kueri terhadap tabel virtual ini harus memiliki penentu region.
[[["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.ORGANIZATION_OPTIONS_CHANGES\u003c/code\u003e view provides real-time metadata on BigQuery configuration changes at both organization and project levels.\u003c/p\u003e\n"],["\u003cp\u003eThis view is subject to the Pre-GA Offerings Terms, meaning it is available "as is" with potentially limited support, and covers changes made after January 31, 2024.\u003c/p\u003e\n"],["\u003cp\u003eAccessing configuration change data requires the \u003ccode\u003ebigquery.config.update\u003c/code\u003e permission, typically granted through the BigQuery Admin IAM role.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view represents a single configuration change, detailing the update time, user, modified options (with old and new values), project ID, and project number.\u003c/p\u003e\n"],["\u003cp\u003eThe data displayed is scoped to the region where the query is executed, using the format \u003ccode\u003eregion-REGION.INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES\u003c/code\u003e, and it retains data for the last 180 days.\u003c/p\u003e\n"]]],[],null,["# ORGANIZATION_OPTIONS_CHANGES view\n=================================\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n| **Note:** To get support or provide feedback for organization-level and project-level configuration changes, contact [bq-project-config-service@google.com](mailto:bq-project-config-service@google.com).\n\nYou can query the `INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES` view to retrieve\nreal-time metadata about BigQuery configuration changes in an\norganization.\nThis view reflects organization-level and project-level configuration changes\nmade after January 31, 2024.\n\nRequired permissions\n--------------------\n\n\nTo get the permission that\nyou need to get the configuration changes,\n\nask your administrator to grant you the\n\n\n[BigQuery Admin](/iam/docs/roles-permissions/bigquery#bigquery.admin) (`roles/bigquery.admin`)\nIAM role on your organization.\n\n\nFor more information about granting roles, see [Manage access to projects, folders, and organizations](/iam/docs/granting-changing-revoking-access).\n\n\nThis predefined role contains the\n` bigquery.config.update`\npermission,\nwhich is required to\nget the configuration changes.\n\n\nYou might also be able to get\nthis permission\nwith [custom roles](/iam/docs/creating-custom-roles) or\nother [predefined roles](/iam/docs/roles-overview#predefined).\n\nSchema\n------\n\nWhen you query the `INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES` view, the query\nresults contain one row for each configuration change in an organization.\n\nThe `INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES` view has the following schema:\n\nData retention\n--------------\n\nThis view contains sessions that are running, and the history of sessions\ncompleted in the past 180 days.\n\nScope and syntax\n----------------\n\nQueries against this view must have a [region qualifier](/bigquery/docs/information-schema-intro#syntax).\n\nReplace the following:\n\n- \u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e: any [dataset region name](/bigquery/docs/locations). For example, `US`, or `us-west2`.\n\n\u003cbr /\u003e\n\nExamples\n--------\n\nThe following example retrieves all changes of the\n`default_query_job_timeout_ms option` option: \n\n```googlesql\nSELECT\n *\nFROM\n `region-\u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e`.INFORMATION_SCHEMA.ORGANIZATION_OPTIONS_CHANGES\nWHERE\n updated_options.default_query_job_timeout_ms is not null;\n```\n| **Note:** `INFORMATION_SCHEMA` view names are case-sensitive.\n\nThe result is similar to the following: \n\n```\n+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+\n| project_number | project_id | update_time | username | updated_options |\n|----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|\n| 4471534625 | myproject1 | 2023-08-22 06:57:49 UTC | user1@gmail.com | {\"default_query_job_timeout_ms\":{\"new\":0,\"old\":1860369},\"default_time_zone\":{\"new\":\"America/New_York\",\"old\":\"\"}} |\n|----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|\n| 5027725474 | myproject2 | 2022-08-01 00:00:00 UTC | user2@gmail.com | {\"default_query_job_timeout_ms\":{\"new\":1860369,\"old\":1860008}} |\n+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+\n```"]]
