Mit Sammlungen den Überblick behalten
Sie können Inhalte basierend auf Ihren Einstellungen speichern und kategorisieren.
Ansicht PROJECT_OPTIONS
Sie können die INFORMATION_SCHEMA.PROJECT_OPTIONS-Ansicht abfragen, um Echtzeit-Metadaten zu den Projektoptionen von BigQuery abzurufen. Diese Ansicht enthält Konfigurationsoptionen, die auf Projektebene festgelegt wurden. Die Standardwerte für eine Konfigurationsoption finden Sie unter Konfigurationseinstellungen.
Erforderliche Berechtigungen
Zum Abrufen der Metadaten der Konfigurationsoptionen benötigen Sie folgende IAM-Berechtigungen (Identity and Access Management):
bigquery.config.get
Die folgende vordefinierte IAM-Rolle enthält die Berechtigungen, die Sie benötigen, um die Metadaten der Projektoptionen abzurufen:
roles/bigquery.jobUser
Weitere Informationen über detaillierte BigQuery-Berechtigungen finden Sie unter Rollen und Berechtigungen.
Schema
Wenn Sie die Ansicht INFORMATION_SCHEMA.PROJECT_OPTIONS abfragen, wird im Ergebnis jede Konfigurationsoption in einem Projekt, die sich vom Standardwert unterscheidet, in einer eigenen Zeile dargestellt.
Die Ansicht INFORMATION_SCHEMA.PROJECT_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.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"]]
