Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tabel virtual EFFECTIVE_PROJECT_OPTIONS
Anda dapat membuat kueri tampilan INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS untuk mengambil metadata real-time tentang opsi project BigQuery yang efektif.
Tampilan ini berisi opsi konfigurasi yang ditetapkan di tingkat organisasi atau project. Jika opsi konfigurasi yang sama ditetapkan di tingkat organisasi dan project, nilai konfigurasi project akan ditampilkan. Untuk melihat nilai
default untuk opsi konfigurasi, lihat setelan
konfigurasi.
Izin yang diperlukan
Untuk mendapatkan metadata opsi project yang efektif, Anda memerlukan izin Identity and Access Management (IAM) bigquery.config.get.
Peran IAM yang telah ditetapkan berikut mencakup izin yang Anda perlukan untuk mendapatkan metadata opsi project yang efektif:
roles/bigquery.jobUser
Untuk mengetahui informasi selengkapnya tentang izin BigQuery terperinci, lihat peran dan izin.
Skema
Saat Anda membuat kueri tabel virtual INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS, hasil kueri akan berisi satu baris untuk setiap konfigurasi dalam sebuah project.
Tabel virtual INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS memiliki skema berikut:
Contoh berikut mengambil kolom OPTION_NAME, OPTION_TYPE, OPTION_VALUE, OPTION_SET_LEVEL, dan OPTION_SET_ON_ID dari tabel virtual INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS.
[[["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.EFFECTIVE_PROJECT_OPTIONS\u003c/code\u003e view provides real-time metadata about BigQuery's effective project options, including default settings at the organization or project levels.\u003c/p\u003e\n"],["\u003cp\u003eAccessing the \u003ccode\u003eEFFECTIVE_PROJECT_OPTIONS\u003c/code\u003e view requires the \u003ccode\u003ebigquery.config.get\u003c/code\u003e IAM permission, which is included in the \u003ccode\u003eroles/bigquery.jobUser\u003c/code\u003e predefined role.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view represents a configuration setting within a project, detailing the option's name, description, data type, set level (e.g., \u003ccode\u003eDEFAULT\u003c/code\u003e, \u003ccode\u003eORGANIZATION\u003c/code\u003e, \u003ccode\u003ePROJECT\u003c/code\u003e), and current value.\u003c/p\u003e\n"],["\u003cp\u003eThe view contains data for currently running sessions and sessions completed in the last 180 days, and queries against this view must use a region qualifier.\u003c/p\u003e\n"],["\u003cp\u003eConfiguration options such as \u003ccode\u003edefault_time_zone\u003c/code\u003e, \u003ccode\u003edefault_kms_key_name\u003c/code\u003e, and query timeouts are available within this view, allowing users to see the current effective settings for a project.\u003c/p\u003e\n"]]],[],null,["# EFFECTIVE_PROJECT_OPTIONS view\n==============================\n\nYou can query the `INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS` view to\nretrieve real-time metadata about BigQuery effective project options.\nThis view contains configuration options that are set at the organization or\nproject level. If the same configuration option is set at both the organization\nand project level, the project configuration value is shown. To view the default\nvalues for a configuration option, see [configuration\nsettings](/bigquery/docs/default-configuration#configuration-settings).\n\nRequired permissions\n--------------------\n\nTo get effective project options metadata, you need the `bigquery.config.get`\nIdentity and Access Management (IAM) permission.\n\nThe following predefined IAM role includes the\npermissions that you need in order to get effective 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.EFFECTIVE_PROJECT_OPTIONS` view, the query results contain one row for each configuration in a project.\n\nThe `INFORMATION_SCHEMA.EFFECTIVE_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`, `OPTION_VALUE`, `OPTION_SET_LEVEL`, and `OPTION_SET_ON_ID` columns from the `INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS` view. \n\n```googlesql\nSELECT\n option_name, option_type, option_value, option_set_level, option_set_on_id\nFROM\n `region-\u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e`.INFORMATION_SCHEMA.EFFECTIVE_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 | option_set_level | option_set_on_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n | default_time_zone | STRING | America/Los_Angeles | organizations | my_organization_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n | default_kms_key_name | STRING | test/testkey1 | projects | my_project_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n | default_query_job_timeout_ms | INT64 | 18000000 | projects | my_project_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n | default_interactive_query_queue_timeout_ms | INT64 | 600000 | organization | my_organization_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n | default_batch_query_queue_timeout_ms | INT64 | 1200000 | projects | my_project_id |\n +--------------------------------------------+-------------+---------------------+------------------+--------------------+\n \n```\n\n\u003cbr /\u003e"]]
