Mantenha tudo organizado com as coleções
Salve e categorize o conteúdo com base nas suas preferências.
Monitorar as reservas do BigQuery
Como administrador do BigQuery, é possível monitorar as reservas no
projeto vendo o uso dele e do slot de reserva, além de
visualizar a fatura com base em capacidade.
Ver projeto e uso de slots de reserva
É possível visualizar o projeto e o uso de slots de reserva das seguintes maneiras:
O campo reservation_id nas visualizações INFORMATION_SCHEMA.JOBS* contém o nome da reserva.
Console do Google Cloud. O Console do Google Cloud inclui gráficos que exibem o uso do slot. Para mais informações, consulte Usar gráficos
de recursos administrativos.
Registros de auditoria. Use registros de auditoria para
ver métricas sobre o uso de slots.
O método Jobs. Use o método da API Jobs
para ver métricas sobre o uso de slots de um job.
Cloud Monitoring. É possível encontrar os slots alocados no
Cloud Monitoring. Essas informações da métrica incluem o uso de slot para cada reserva e tipo de job. As informações também podem ser visualizadas
usando o os gráficos personalizados do Metrics Explorer.
Ver sua fatura com base em capacidade
Para ver sua fatura com base em capacidade em tempo real, siga estas etapas:
No console do Google Cloud, abra a página Faturamento.
Selecione o projeto da conta de faturamento do qual você quer ver a fatura.
Navegue até a seção Relatórios e, em seguida, na seção Filtros, faça
o seguinte:
Na lista Serviços, selecione BigQuery e selecione todos os
aplicáveis.
Selecione Todas as SKUs na lista SKUs.
Atribuição de custo de reserva
Esse recurso permite que você atribua taxas de reserva de volta ao uso de consulta
específico em todos os projetos que usaram a reserva. Isso resulta em custos líquidos mais precisos para cada base de projeto.
Todos os clientes da API BigQuery Reservations têm um item de linha de atribuição de slots de análise nos dados do Faturamento do Cloud, indicando a parcela dos slots reservados consumidos em cada um deles. Isso inclui o portal Faturamento e a
exportação do Cloud Billing. O custo desse novo item é zero. Essas alterações
não afetam o valor total da fatura.
Registros de auditoria
A criação, a exclusão e a atualização de recursos relacionados às
reservas do BigQuery são
registradas nos registros de auditoria do proprietário do projeto.
Para mais informações, consulte Registro de auditoria.
[[["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 2025-03-25 UTC."],[[["\u003cp\u003eBigQuery administrators can monitor project and reservation slot usage through \u003ccode\u003eINFORMATION_SCHEMA\u003c/code\u003e views, the Google Cloud console, audit logs, the \u003ccode\u003eJobs\u003c/code\u003e API method, and Cloud Monitoring.\u003c/p\u003e\n"],["\u003cp\u003eYou can view your real-time capacity-based bill in the Google Cloud console's Billing page by filtering for BigQuery services and SKUs.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery's "Analysis Slots Attribution" feature provides a breakdown of reserved slot usage across projects in Cloud Billing data without affecting invoice totals.\u003c/p\u003e\n"],["\u003cp\u003eAudit logs record the creation, deletion, and updates of BigQuery reservation resources, providing a detailed history of changes.\u003c/p\u003e\n"],["\u003cp\u003eThe amount of slots that are in use might appear to be higher than the reservation slot count due to how BigQuery provisions resources, however, users will not be charged for the slots that go beyond their reservation slot count.\u003c/p\u003e\n"]]],[],null,["# Monitor BigQuery reservations\n=============================\n\nAs a BigQuery administrator, you can monitor reservations in your\nproject by viewing the project and reservation slot usage and also view\nyour capacity-based bill.\n\nView project and reservation slot usage\n---------------------------------------\n\nYou can view the project and reservation slot usage in the following ways:\n\n- **`INFORMATION_SCHEMA` views.** To retrieve project and reservation usage\n information, query the [`INFORMATION_SCHEMA.JOBS*` views](/bigquery/docs/information-schema-jobs#examples).\n\n The [`reservation_id`](/bigquery/docs/information-schema-jobs#schema) field\n in the `INFORMATION_SCHEMA.JOBS*` views contains the reservation name.\n- **Google Cloud console.** The Google Cloud console includes charts that\n display slot usage. For more information, see [Use administrative\n resource charts](/bigquery/docs/admin-resource-charts).\n\n- **Audit logs.** Use [audit logs](/bigquery/docs/reference/auditlogs) to\n view metrics about slot usage.\n\n- **The `Jobs` method.** Use the [`Jobs` API method](/bigquery/docs/reference/rest/v2/jobs)\n to view metrics about slot usage for a job.\n\n- **Cloud Monitoring.** You can use [Cloud Monitoring](/bigquery/docs/monitoring-dashboard) to create dashboards to monitor your allocated slots. With a Cloud Monitoring dashboard, you can view your slot usage for each reservation and for each job type, across all projects within the reservation. For more information about the metrics available for the Cloud Monitoring dashboard, see [Metrics available for visualization](/bigquery/docs/monitoring-dashboard#metrics).\n\n| **Note:** The number of slots in use might appear higher than your reservation slot count because of how BigQuery provisions resources to reservations. You are not charged for slots beyond your reservation slot count.\n\nView your capacity-based bill\n-----------------------------\n\nTo view your capacity-based bill in real time, follow these steps:\n\n1. In the Google Cloud console, go to the **Billing** page.\n\n [Go to **Billing**](https://console.cloud.google.com/billing).\n2. Select the billing account project for which you want to view the bill.\n\n3. Navigate to the **Reports** section and then in the **Filters** section, do\n the following:\n\n 1. From the **Services** list, select **BigQuery** and select all that's applicable.\n 2. Select **All SKUs** from the **SKUs** list.\n\n| **Note:** BigQuery annual and three-year commitments are priced by months. Your bill doesn't change due to variability in the month length. If your slot usage remains unchanged, the rate remains the same every month.\n\nReservation cost attribution\n----------------------------\n\nThis feature lets you attribute reservation fees back to the specific query\nusage across any projects that used the reservation. This results in more\naccurate net costs for each project basis.\n\nAll [BigQuery Reservations API](/bigquery/docs/reservations-commitments#enabling-reservations-api)\ncustomers have an **\"Analysis Slots Attribution\"** line item in their\nCloud Billing data. This line item is included on the **Billing** page\nand in the Cloud Billing export.\n\nThis line item shows slot hours used per project. It incurs no cost and doesn't\naffect your invoice totals.\n\nAudit logs\n----------\n\nCreating, deleting, and updating resources related to\n[BigQuery reservations](/bigquery/docs/reservations-concepts) are\nrecorded in the project owner's audit logs.\nFor more information, see [Audit log](/bigquery/docs/reference/auditlogs#auditlog_format).\n\nWhat's next\n-----------\n\n- Learn about [capacity commitment plans](/bigquery/docs/reservations-workload-management#slot_commitments).\n- Learn how to [use administrative resource charts](/bigquery/docs/admin-resource-charts).\n- Learn about [BigQuery pricing](/bigquery/pricing)."]]
