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’s infrastructure. Simply move your data into BigQuery and let us handle the hard work. 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.

Use the OpsRamp Google public cloud integration to discover and collect metrics against the Google service.

Setup

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

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

Event support

  • Supported
  • Configurable in OpsRamp Google Integration Discovery Profile.

External reference