Google BigQuery monitoring

  • How-to guide
  • 1-min read
  • Published Jan 17, 2022

Dynatrace Google Cloud integration leverages data collected from the Google Operation API to constantly monitor health and performance of Google Cloud Services. While combining all relevant data into dashboards, it also enables alerting and event tracking.

Prerequisites

Set up integration

Add services and feature sets optional

After integration, Dynatrace automatically monitors a number of preset Google Cloud services and feature sets (metrics). Besides these, you can add more services or feature sets to monitoring. For details, see Add or remove services.

For a list of feature sets available for this service, see Metric table.

View metrics

After deploying the integration, you can see metrics from monitored services in the Metrics browser, Data Explorer, and your dashboard tiles.

Metric table

The following feature sets are available for Google BigQuery.

Feature setNameUnitGCP metric identifier
bigquery_biengine_model/default_metricsInflight requestsCountbigquerybiengine.googleapis.com/model/inflight_requests
bigquery_biengine_model/default_metricsRequest countCountbigquerybiengine.googleapis.com/model/request_count
bigquery_biengine_model/default_metricsRequest execution timesMilliSecondbigquerybiengine.googleapis.com/model/request_latencies
bigquery_project/default_metricsJob countCountbigquery.googleapis.com/job/num_in_flight
bigquery_project/default_metricsQuery countCountbigquery.googleapis.com/query/count
bigquery_project/default_metricsQuery execution timesSecondbigquery.googleapis.com/query/execution_times
bigquery_project/default_metricsSlots used by project, reservation, and job typeCountbigquery.googleapis.com/slots/allocated
bigquery_project/default_metricsSlots assignedCountbigquery.googleapis.com/slots/assigned
bigquery_project/default_metricsSlots capacity committedCountbigquery.googleapis.com/slots/capacity_committed
bigquery_project/default_metricsSlots max assignedCountbigquery.googleapis.com/slots/max_assigned
bigquery_project/default_metricsSlots used across projects in reservationCountbigquery.googleapis.com/slots/total_allocated_for_reservation
bigquery_project/default_metricsTotal slotsCountbigquery.googleapis.com/slots/total_available
bigquery_project/default_metricsReservation total bytesBytebigquerybiengine.googleapis.com/reservation/total_bytes
bigquery_project/default_metricsReservation used bytesBytebigquerybiengine.googleapis.com/reservation/used_bytes
Related tags
Infrastructure Observability