Storing and querying massive datasets can be time consuming and expensive without the right hardware and infrastructure. BigQuery is an enterprise data warehouse that solves this problem by enabling super-fast SQL queries using the processing power of Google infrastructure. Move your data into BigQuery so you can control access to both the project and your data based on your business needs, such as giving others the ability to view or query your data.

To set up the Google integration to discover and collect metrics against the Google service.

External reference

Setup

To set up the Google integration and discover the Google service, go to Google Integration Discovery Profile and select BigQuery.

Event support

  • Supported
  • Configurable in OpsRamp Google Integration Discovery Profile.

Supported metrics

OpsRamp MetricMetric Display NameUnitAggregation Type
google_bigquery_storage_table_count

Number of tables.
Table countCountAverage
google_bigquery_storage_stored_bytes

Number of bytes stored.
Stored bytesBytesAverage
google_bigquery_storage_uploaded_bytes

Number of bytes uploaded.
Uploaded bytesBytesAverage
google_bigquery_storage_uploaded_bytes_billed

Uploaded bytes billed.
Uploaded bytes billedBytesAverage
google_bigquery_storage_uploaded_row_count

Uploaded rows.
Uploaded rowsCountAverage