Tetap teratur dengan koleksi
Simpan dan kategorikan konten berdasarkan preferensi Anda.
Tampilan ORGANIZATION_OPTIONS
Anda dapat membuat kueri tampilan INFORMATION_SCHEMA.ORGANIZATION_OPTIONS untuk mengambil metadata real-time tentang opsi organisasi BigQuery. Tampilan ini
berisi opsi konfigurasi yang ditetapkan di tingkat organisasi.
Untuk melihat nilai default opsi konfigurasi, lihat setelan
konfigurasi.
Izin yang diperlukan
Untuk mendapatkan metadata opsi organisasi, 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 organisasi:
roles/bigquery.jobUser
Untuk mengetahui informasi selengkapnya tentang izin BigQuery terperinci, lihat peran dan izin.
Skema
Saat Anda membuat kueri tampilan INFORMATION_SCHEMA.ORGANIZATION_OPTIONS, hasil kueri akan berisi satu baris untuk setiap opsi konfigurasi dalam project, jika opsi tersebut berbeda dari nilai default di tingkat organisasi.
Tampilan INFORMATION_SCHEMA.ORGANIZATION_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.ORGANIZATION_OPTIONS\u003c/code\u003e view provides real-time metadata about BigQuery organization options that differ from default values.\u003c/p\u003e\n"],["\u003cp\u003eAccessing this 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\u003eThe view's schema includes columns for \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, detailing each configuration option.\u003c/p\u003e\n"],["\u003cp\u003eThe available options include \u003ccode\u003edefault_time_zone\u003c/code\u003e, \u003ccode\u003edefault_kms_key_name\u003c/code\u003e, and various timeout settings for query jobs.\u003c/p\u003e\n"],["\u003cp\u003eQueries to this view must include a region qualifier and can be used to see options set for the previous 180 days of data, such as in the example, which shows how to retrieve the name, type, and value of each option.\u003c/p\u003e\n"]]],[],null,["# ORGANIZATION_OPTIONS view\n=========================\n\nYou can query the `INFORMATION_SCHEMA.ORGANIZATION_OPTIONS` view to retrieve\nreal-time metadata about BigQuery organization options. This view\ncontains configuration options that are set at the organization level.\nTo view the default values for a configuration option, see [configuration\nsettings](/bigquery/docs/default-configuration#configuration-settings).\n\nRequired permissions\n--------------------\n\nTo get organization 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 organization 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.ORGANIZATION_OPTIONS` view, the query\nresults contain one row for each configuration option in a project, if that\noption differs from the default value at the organization level.\n\nThe `INFORMATION_SCHEMA.ORGANIZATION_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.ORGANIZATION_OPTIONS`. \n\n```googlesql\nSELECT\n option_name, option_type, option_value\nFROM\n `region-us`.INFORMATION_SCHEMA.ORGANIZATION_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"]]
