Mit Sammlungen den Überblick behalten
Sie können Inhalte basierend auf Ihren Einstellungen speichern und kategorisieren.
Ansicht EFFECTIVE_PROJECT_OPTIONS
Sie können die INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS-Ansicht abfragen, um Echtzeit-Metadaten zu den effektiven Projektoptionen von BigQuery abzurufen.
Diese Ansicht enthält Konfigurationsoptionen, die auf Organisations- oder Projektebene festgelegt sind. Wenn dieselbe Konfigurationsoption sowohl auf Organisations- als auch auf Projektebene festgelegt ist, wird der Konfigurationswert des Projekts angezeigt. Die Standardwerte für eine Konfigurationsoption finden Sie in den Konfigurationseinstellungen.
Erforderliche Berechtigungen
Zum Abrufen der Metadaten der gültigen Projektoptionen benötigen Sie die IAM-Berechtigung (Identity and Access Management) bigquery.config.get.
Die folgende vordefinierte IAM-Rolle enthält die Berechtigungen, die Sie benötigen, um die Metadaten effektiver Projektoptionen abzurufen:
roles/bigquery.jobUser
Weitere Informationen über detaillierte BigQuery-Berechtigungen finden Sie unter Rollen und Berechtigungen.
Schema
Wenn Sie die INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS-Ansicht abfragen, wird im Ergebnis jede Konfiguration in einem Projekt in einer eigenen Zeile dargestellt.
Die Ansicht INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS hat das folgende Schema:
Im folgenden Beispiel werden die Spalten OPTION_NAME, OPTION_TYPE, OPTION_VALUE, OPTION_SET_LEVEL und OPTION_SET_ON_ID aus der INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS-Ansicht abgerufen.
[[["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.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"]]
