[[["易于理解","easyToUnderstand","thumb-up"],["解决了我的问题","solvedMyProblem","thumb-up"],["其他","otherUp","thumb-up"]],[["很难理解","hardToUnderstand","thumb-down"],["信息或示例代码不正确","incorrectInformationOrSampleCode","thumb-down"],["没有我需要的信息/示例","missingTheInformationSamplesINeed","thumb-down"],["翻译问题","translationIssue","thumb-down"],["其他","otherDown","thumb-down"]],["最后更新时间 (UTC)：2025-04-21。"],[[["\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"]]
