Docs » Integrations Guide » Integrations Reference » Google BigQuery

image0 Google BigQuery

DESCRIPTION

Use SignalFx to monitor Google BigQuery via Google Cloud Platform.

FEATURES

Built-in dashboards

  • BigQuery Overview: Overview of project level metrics for Google BigQuery.

image1

INSTALLATION

To access this integration, connect to Google Cloud Platform.

USAGE

Interpreting Built-in dashboards

BigQuery Overview

  • Queries Count - Number of in flight queries.
  • Queries Trend - Shows the trend of number of in flight queries.
  • Scanned Bytes / min - Number of bytes scanned per minute.
  • Average Execution Time - Distribution of queries execution times in seconds.
  • Slots Allocated vs. Slots Available - Number of BigQuery slots currently allocated for the project vs total number of BigQuery slots available for the project.
  • Scanned Bytes Billed / min - Amount of Scanned bytes billed per minute.
  • Top Uploaded Bytes Billed per Table - Tables with top 5 uploaded bytes billed per minute.
  • Top Stored Bytes per Table - Tables with top 5 stored bytes.
  • Top Uploaded Bytes per Table - Tables with top 5 uploaded bytes.
  • Table Count - Total number of tables in the project.
  • Rows Uploaded / min per Table - List number of rows uploaded per min aggregated by table.

METRICS

For more information about the metrics emitted by Google BigQuery, visit the service’s metric page at https://cloud.google.com/monitoring/api/metrics#gcp-bigquery

Below is a list of all metrics.

Metric Name Brief Type
query_count In flight queries. gauge
query_execution_times Distribution of queries execution times. gauge
query_scanned_bytes Scanned bytes per minute. derive
query_scanned_bytes_billed Scanned bytes billed per minute. derive
slots_allocated_for_project Number of BigQuery slots currently allocated for the project. gauge
slots_total_available Total number of BigQuery slots available for the project. gauge
storage_stored_bytes Number of bytes stored. gauge
storage_table_count Number of tables. gauge
storage_uploaded_bytes Uploaded bytes per minute. derive
storage_uploaded_bytes_billed Uploaded bytes billed per minute. derive
storage_uploaded_row_count Uploaded rows per minute. derive

query_count

gauge

In flight queries.

query_execution_times

gauge

Distribution of queries execution times.

query_scanned_bytes

derive

Scanned bytes per minute.

query_scanned_bytes_billed

derive

Scanned bytes billed per minute.

slots_allocated_for_project

gauge

Number of BigQuery slots currently allocated for the project.

slots_total_available

gauge

Total number of BigQuery slots available for the project.

storage_stored_bytes

gauge

Number of bytes stored.

storage_table_count

gauge

Number of tables.

storage_uploaded_bytes

derive

Uploaded bytes per minute.

storage_uploaded_bytes_billed

derive

Uploaded bytes billed per minute.

storage_uploaded_row_count

derive

Uploaded rows per minute.