Organiza tus páginas con colecciones
Guarda y categoriza el contenido según tus preferencias.
Vista de PROJECT_OPTIONS
Puedes consultar la vista INFORMATION_SCHEMA.PROJECT_OPTIONS para recuperar metadatos en tiempo real sobre las opciones de proyecto de BigQuery. Esta vista contiene la configuración predeterminada a nivel del proyecto.
Permisos necesarios
Para obtener los metadatos de opciones de configuración, necesitas los siguientes permisos de Identity and Access Management (IAM):
bigquery.config.get
El siguiente rol predefinido de IAM incluye los permisos que necesitas para obtener los metadatos de las opciones del proyecto:
roles/bigquery.jobUser
Si deseas obtener más información acerca de los permisos de BigQuery en detalle, consulta los roles y las permisos.
Esquema
Cuando consultas la vista INFORMATION_SCHEMA.PROJECT_OPTIONS, los resultados contienen una fila por cada configuración de un proyecto.
La vista INFORMATION_SCHEMA.PROJECT_OPTIONS tiene el siguiente esquema:
[[["Fácil de comprender","easyToUnderstand","thumb-up"],["Resolvió mi problema","solvedMyProblem","thumb-up"],["Otro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Información o código de muestra incorrectos","incorrectInformationOrSampleCode","thumb-down"],["Faltan la información o los ejemplos que necesito","missingTheInformationSamplesINeed","thumb-down"],["Problema de traducción","translationIssue","thumb-down"],["Otro","otherDown","thumb-down"]],["Última actualización: 2024-12-22 (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"]]
