Stay organized with collections
Save and categorize content based on your preferences.
EFFECTIVE_PROJECT_OPTIONS view
You can query the INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view to
retrieve real-time metadata about BigQuery effective project options.
This view contains configuration options that are set at the organization or
project level. If the same configuration option is set at both the organization
and project level, the project configuration value is shown. To view the default
values for a configuration option, see configuration
settings.
Required permissions
To get effective project options metadata, you need the bigquery.config.get
Identity and Access Management (IAM) permission.
The following predefined IAM role includes the
permissions that you need in order to get effective project options metadata:
roles/bigquery.jobUser
For more information about granular BigQuery permissions, see
roles and permissions.
Schema
When you query the INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view, the query results contain one row for each configuration in a project.
The INFORMATION_SCHEMA.EFFECTIVE_PROJECT_OPTIONS view has the following schema:
The 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.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-09-03 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"]]
