Mit Sammlungen den Überblick behalten
Sie können Inhalte basierend auf Ihren Einstellungen speichern und kategorisieren.
Ansicht ORGANIZATION_OPTIONS
Sie können die Ansicht INFORMATION_SCHEMA.ORGANIZATION_OPTIONS abfragen, um Echtzeit-Metadaten zu den Organisationsoptionen von BigQuery abzurufen. Diese Ansicht enthält Konfigurationsoptionen, die auf Organisationsebene festgelegt sind.
Die Standardwerte für eine Konfigurationsoption finden Sie unter Konfigurationseinstellungen.
Erforderliche Berechtigungen
Zum Abrufen der Metadaten der Organisationsoptionen benötigen Sie folgende IAM-Berechtigungen (Identity and Access Management):
bigquery.config.get
Die folgende vordefinierte IAM-Rolle enthält die Berechtigungen, die Sie zum Abrufen der Options-Metadaten einer Organisation benötigen:
roles/bigquery.jobUser
Weitere Informationen über detaillierte BigQuery-Berechtigungen finden Sie unter Rollen und Berechtigungen.
Schema
Wenn Sie die Ansicht INFORMATION_SCHEMA.ORGANIZATION_OPTIONS abfragen, enthält das Ergebnis für jede Konfigurationsoption in einem Projekt eine Zeile, sofern sich diese Option vom Standardwert auf Organisationsebene unterscheidet.
Die Ansicht INFORMATION_SCHEMA.ORGANIZATION_OPTIONS hat das folgende Schema:
[[["Leicht verständlich","easyToUnderstand","thumb-up"],["Mein Problem wurde gelöst","solvedMyProblem","thumb-up"],["Sonstiges","otherUp","thumb-up"]],[["Schwer verständlich","hardToUnderstand","thumb-down"],["Informationen oder Beispielcode falsch","incorrectInformationOrSampleCode","thumb-down"],["Benötigte Informationen/Beispiele nicht gefunden","missingTheInformationSamplesINeed","thumb-down"],["Problem mit der Übersetzung","translationIssue","thumb-down"],["Sonstiges","otherDown","thumb-down"]],["Zuletzt aktualisiert: 2025-08-17 (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"]]
