Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Visualização de PROJECT_OPTIONS
É possível consultar a visualização INFORMATION_SCHEMA.PROJECT_OPTIONS para recuperar metadados em tempo real sobre as opções do projeto do BigQuery. Essa visualização contém configurações padrão no nível do projeto.
Permissões necessárias
Para receber metadados de opções da configuração, você precisa das seguintes permissões de gerenciamento de identidade e acesso (IAM):
bigquery.config.get
O papel predefinido do IAM a seguir inclui as
permissões necessárias para receber metadados de opções de projeto:
roles/bigquery.jobUser
Para mais informações sobre permissões granulares do BigQuery, consulte
papéis e permissões.
Esquema
Quando você consulta a visualização INFORMATION_SCHEMA.PROJECT_OPTIONS, os resultados da consulta contêm uma linha para cada configuração em um projeto.
A visualização INFORMATION_SCHEMA.PROJECT_OPTIONS tem o seguinte esquema:
[[["Fácil de entender","easyToUnderstand","thumb-up"],["Meu problema foi resolvido","solvedMyProblem","thumb-up"],["Outro","otherUp","thumb-up"]],[["Difícil de entender","hardToUnderstand","thumb-down"],["Informações incorretas ou exemplo de código","incorrectInformationOrSampleCode","thumb-down"],["Não contém as informações/amostras de que eu preciso","missingTheInformationSamplesINeed","thumb-down"],["Problema na tradução","translationIssue","thumb-down"],["Outro","otherDown","thumb-down"]],["Última atualização 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"]]
