INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS 뷰를 쿼리하여 BigQuery 유효 프로젝트 옵션에 대한 실시간 메타데이터를 검색할 수 있습니다.
이 뷰에는 조직 또는 프로젝트 수준에서 설정된 구성 옵션이 포함됩니다. 동일한 구성 옵션이 조직 수준과 프로젝트 수준 모두에서 설정된 경우 프로젝트 구성 값이 표시됩니다. 구성 옵션의 기본값을 보려면 구성 설정을 참조하세요.
필수 권한
효과적인 프로젝트 옵션 메타데이터를 가져오려면 bigquery.config.get Identity and Access Management(IAM) 권한이 필요합니다.
다음과 같은 사전 정의된 IAM 역할에는 유효 프로젝트 옵션 메타데이터를 가져오기 위해 필요한 권한이 포함되어 있습니다.
[[["이해하기 쉬움","easyToUnderstand","thumb-up"],["문제가 해결됨","solvedMyProblem","thumb-up"],["기타","otherUp","thumb-up"]],[["이해하기 어려움","hardToUnderstand","thumb-down"],["잘못된 정보 또는 샘플 코드","incorrectInformationOrSampleCode","thumb-down"],["필요한 정보/샘플이 없음","missingTheInformationSamplesINeed","thumb-down"],["번역 문제","translationIssue","thumb-down"],["기타","otherDown","thumb-down"]],["최종 업데이트: 2025-09-04(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"]]
