Stay organized with collections
Save and categorize content based on your preferences.
PROJECT_OPTIONS view
You can query the INFORMATION_SCHEMA.PROJECT_OPTIONS view to retrieve
real-time metadata about BigQuery project options. This view contains
configuration options that have been set at the project level. To view the
default values for a configuration option, see configuration
settings.
Required permissions
To get configuration options metadata, you need the following Identity and Access Management (IAM) permissions:
bigquery.config.get
The following predefined IAM role includes the
permissions that you need in order to get project options metadata:
roles/bigquery.jobUser
For more information about granular BigQuery permissions, see
roles and permissions.
Schema
When you query the INFORMATION_SCHEMA.PROJECT_OPTIONS view, the query results contain
one row for each configuration option in a project that differs from the default value.
The INFORMATION_SCHEMA.PROJECT_OPTIONS view has the following schema:
[[["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-08-29 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"]]