Google BigQuery monitoring

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 set
Name
Unit
GCP metric identifier
bigquery_biengine_model/default_metrics
Inflight requests
Count
bigquerybiengine.googleapis.com/model/inflight_requests
bigquery_biengine_model/default_metrics
Request count
Count
bigquerybiengine.googleapis.com/model/request_count
bigquery_biengine_model/default_metrics
Request execution times
MilliSecond
bigquerybiengine.googleapis.com/model/request_latencies
bigquery_project/default_metrics
Job count
Count
bigquery.googleapis.com/job/num_in_flight
bigquery_project/default_metrics
Query count
Count
bigquery.googleapis.com/query/count
bigquery_project/default_metrics
Query execution times
Second
bigquery.googleapis.com/query/execution_times
bigquery_project/default_metrics
Slots used by project, reservation, and job type
Count
bigquery.googleapis.com/slots/allocated
bigquery_project/default_metrics
Slots assigned
Count
bigquery.googleapis.com/slots/assigned
bigquery_project/default_metrics
Slots capacity committed
Count
bigquery.googleapis.com/slots/capacity_committed
bigquery_project/default_metrics
Slots max assigned
Count
bigquery.googleapis.com/slots/max_assigned
bigquery_project/default_metrics
Slots used across projects in reservation
Count
bigquery.googleapis.com/slots/total_allocated_for_reservation
bigquery_project/default_metrics
Total slots
Count
bigquery.googleapis.com/slots/total_available
bigquery_project/default_metrics
Reservation total bytes
Byte
bigquerybiengine.googleapis.com/reservation/total_bytes
bigquery_project/default_metrics
Reservation used bytes
Byte
bigquerybiengine.googleapis.com/reservation/used_bytes