Stay organized with collections
Save and categorize content based on your preferences.
PROJECT_OPTIONS_CHANGES view
You can query the INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view to retrieve
real-time metadata about BigQuery configuration changes of a project.
This view reflects project-level configuration changes
made after January 31, 2024.
Required permissions
To get the configuration, you need the bigquery.config.update
Identity and Access Management (IAM) permission at the project level. The predefined
IAM role roles/bigquery.admin includes the permissions that you
need to create a configuration.
For more information about granular BigQuery permissions, see
roles and permissions.
Schema
When you query the INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view, the query
results contain one row for each configuration change in a project.
The INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES view has the following schema:
Column name
Data type
Value
update_time
TIMESTAMP
The time the configuration change occurred.
username
STRING
For first-party users, it's their user email. For third-party users, it's
the name that users set in the third-party identity provider.
updated_options
JSON
A JSON object of the configuration options users updated in the
change, containing the previous and the new values of updated fields.
project_id
STRING
The project ID. This field is empty for organization-level
configuration changes.
project_number
INTEGER
The project number. This field is empty for the organization-level
configuration changes.
Data retention
This view contains sessions that are running and the history of sessions
completed in the past 180 days.
[[["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-25 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eINFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES\u003c/code\u003e view provides real-time metadata about BigQuery project configuration changes made after January 31, 2024.\u003c/p\u003e\n"],["\u003cp\u003eAccessing configuration details via this view requires the \u003ccode\u003ebigquery.config.update\u003c/code\u003e IAM permission at the project level.\u003c/p\u003e\n"],["\u003cp\u003eEach row in the view represents a configuration change, detailing the update time, the user who made the change, the updated options in JSON format, and the associated project ID and number.\u003c/p\u003e\n"],["\u003cp\u003eThis view retains data on running sessions and completed sessions within the past 180 days, and it must be queried with a region qualifier.\u003c/p\u003e\n"],["\u003cp\u003eThis feature is currently a Pre-GA feature meaning that it is available "as is" with limited support.\u003c/p\u003e\n"]]],[],null,["# PROJECT_OPTIONS_CHANGES view\n============================\n\n|\n| **Preview**\n|\n|\n| This feature is subject to the \"Pre-GA Offerings Terms\" in the General Service Terms section\n| of the [Service Specific Terms](/terms/service-terms#1).\n|\n| Pre-GA features are available \"as is\" and might have limited support.\n|\n| For more information, see the\n| [launch stage descriptions](/products#product-launch-stages).\n| **Note:** To get support or provide feedback for project-level configuration changes, contact [bq-project-config-service@google.com](mailto:bq-project-config-service@google.com).\n\nYou can query the `INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES` view to retrieve\nreal-time metadata about BigQuery configuration changes of a project.\nThis view reflects project-level configuration changes\nmade after January 31, 2024.\n\nRequired permissions\n--------------------\n\nTo get the configuration, you need the `bigquery.config.update`\nIdentity and Access Management (IAM) permission at the project level. The predefined\nIAM role `roles/bigquery.admin` includes the permissions that you\nneed to create a configuration.\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_CHANGES` view, the query\nresults contain one row for each configuration change in a project.\n\nThe `INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES` view has the following schema:\n\nData retention\n--------------\n\nThis view contains sessions that are running and the history of sessions\ncompleted 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, `US`, or `us-west2`.\n\n\u003cbr /\u003e\n\n| **Note:** To learn how to extract a JSON scalar value from the `updated_options` column and convert it to a SQL STRING value such as `JSON_VALUE()`, see [JSON functions](/bigquery/docs/reference/standard-sql/json_functions#categories).\n\nExamples\n--------\n\nThe following example retrieves all columns from the\n`INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES` view. \n\n```googlesql\nSELECT\n *\nFROM\n `region-\u003cvar translate=\"no\"\u003eREGION\u003c/var\u003e`.INFORMATION_SCHEMA.PROJECT_OPTIONS_CHANGES;\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| project_number | project_id | update_time | username | updated_options |\n|----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|\n| 4471534625 | myproject1 | 2023-08-22 06:57:49 UTC | user1@gmail.com | {\"default_query_job_timeout_ms\":{\"new\":0,\"old\":1860369},\"default_time_zone\":{\"new\":\"America/New_York\",\"old\":\"\"}} |\n|----------------|------------|-------------------------|-----------------|------------------------------------------------------------------------------------------------------------------|\n| 5027725474 | myproject2 | 2022-08-01 00:00:00 UTC | user2@gmail.com | {\"default_interactive_query_queue_timeout_ms\":{\"new\":1860369,\"old\":1860008}} |\n+----------------+------------+-------------------------+-----------------+------------------------------------------------------------------------------------------------------------------+\n```\n\n\u003cbr /\u003e"]]
