Google BigQuery monitoring
Dynatrace GCP integration leverages data collected from the Google Operation API to constantly monitor health and performance of Google Cloud Platform Services. While combining all relevant data into dashboards, it also enables alerting and event tracking.
Prerequisites
Add services and feature sets optional
After integration, Dynatrace automatically monitors a number of preset GCP 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, the 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 |