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.
Extensions for GCP services
After adding a service to monitoring, it appears as an enabled extension in Dynatrace. Then, your dashboards and metric events are instantly available in your Dynatrace environment. To see the list of extensions, in the Dynatrace menu, go to Extensions.
Note: If you want to stop a service from sending metrics to Dynatrace, removing the relevant extension isn't enough. You also need to remove the service from monitoring. For details, see Add or remove services.
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 |