Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tabel virtual PROJECT_OPTIONS
Anda dapat membuat kueri tampilan INFORMATION_SCHEMA.PROJECT_OPTIONS untuk mengambil
metadata real-time tentang opsi project BigQuery. Tampilan ini berisi opsi konfigurasi yang telah ditetapkan di tingkat project. Untuk melihat nilai default opsi konfigurasi, lihat setelan konfigurasi.
Izin yang diperlukan
Untuk mendapatkan metadata opsi konfigurasi, Anda memerlukan izin Identity and Access Management (IAM) berikut:
bigquery.config.get
Peran IAM yang telah ditetapkan berikut mencakup izin yang Anda perlukan untuk mendapatkan metadata opsi project:
roles/bigquery.jobUser
Untuk mengetahui informasi selengkapnya tentang izin BigQuery secara terperinci, lihat peran dan izin.
Skema
Saat Anda membuat kueri tampilan INFORMATION_SCHEMA.PROJECT_OPTIONS, hasil kueri akan berisi
satu baris untuk setiap opsi konfigurasi dalam project yang berbeda dari nilai default.
Tampilan INFORMATION_SCHEMA.PROJECT_OPTIONS memiliki skema berikut:
[[["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.PROJECT_OPTIONS\u003c/code\u003e view provides real-time metadata on BigQuery project configuration options that deviate from default values.\u003c/p\u003e\n"],["\u003cp\u003eTo access this metadata, users require the \u003ccode\u003ebigquery.config.get\u003c/code\u003e IAM permission, which is included in the \u003ccode\u003eroles/bigquery.jobUser\u003c/code\u003e role.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view represents a project configuration option that is not set to the default, detailing the \u003ccode\u003eOPTION_NAME\u003c/code\u003e, \u003ccode\u003eOPTION_DESCRIPTION\u003c/code\u003e, \u003ccode\u003eOPTION_TYPE\u003c/code\u003e, and \u003ccode\u003eOPTION_VALUE\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eThe view contains information on several options, including \u003ccode\u003edefault_time_zone\u003c/code\u003e, \u003ccode\u003edefault_kms_key_name\u003c/code\u003e, and various query timeout settings.\u003c/p\u003e\n"],["\u003cp\u003eQueries to the \u003ccode\u003ePROJECT_OPTIONS\u003c/code\u003e view must include a region qualifier, specifying the dataset region, such as \u003ccode\u003eregion-us\u003c/code\u003e.\u003c/p\u003e\n"]]],[],null,["# PROJECT_OPTIONS view\n====================\n\nYou can query the `INFORMATION_SCHEMA.PROJECT_OPTIONS` view to retrieve\nreal-time metadata about BigQuery project options. This view contains\nconfiguration options that have been set at the project level. To view the\ndefault values for a configuration option, see [configuration\nsettings](/bigquery/docs/default-configuration#configuration-settings).\n\nRequired permissions\n--------------------\n\nTo get configuration options metadata, you need the following Identity and Access Management (IAM) permissions:\n\n- `bigquery.config.get`\n\nThe following predefined IAM role includes the\npermissions that you need in order to get project options metadata:\n\n- `roles/bigquery.jobUser`\n\nFor more information about granular BigQuery permissions, see\n[roles and permissions](/bigquery/docs/access-control).\n\nSchema\n------\n\nWhen you query the `INFORMATION_SCHEMA.PROJECT_OPTIONS` view, the query results contain\none row for each configuration option in a project that differs from the default value.\n\nThe `INFORMATION_SCHEMA.PROJECT_OPTIONS` view has the following schema:\n\n##### Options table\n\nData retention\n--------------\n\nThis view contains currently running sessions and the history of sessions completed 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, `region-us`.\n\n\u003cbr /\u003e\n\nExamples\n--------\n\nThe following example retrieves the `OPTION_NAME`, `OPTION_TYPE`, and `OPTION_VALUE` columns from the `INFORMATION_SCHEMA.PROJECT_OPTIONS` view. \n\n```googlesql\nSELECT\n option_name, option_type, option_value\nFROM\n `region-\u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e`.INFORMATION_SCHEMA.PROJECT_OPTIONS;\n```\n| **Note:** `INFORMATION_SCHEMA` view names are case-sensitive.\n\nThe result is similar to the following:\n\n\u003cbr /\u003e\n\n```\n +--------------------------------------------+-------------+---------------------+\n | option_name | option_type | option_value |\n +--------------------------------------------+-------------+---------------------+\n | default_time_zone | STRING | America/Los_Angeles |\n +--------------------------------------------+-------------+---------------------+\n | default_kms_key_name | STRING | test/testkey1 |\n +--------------------------------------------+-------------+---------------------+\n | default_query_job_timeout_ms | INT64 | 18000000 |\n +--------------------------------------------+-------------+---------------------+\n | default_interactive_query_queue_timeout_ms | INT64 | 600000 |\n +--------------------------------------------+-------------+---------------------+\n | default_batch_query_queue_timeout_ms | INT64 | 1200000 |\n +--------------------------------------------+-------------+---------------------+\n \n```\n\n\u003cbr /\u003e"]]
