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
GCP BigQuery Dataset
| OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_bigquery_storage_stored_bytes | bigquery.googleapis.com/storage/stored_bytes | Stored bytes | bytes | Number of logical bytes stored. The top 100 tables in a dataset are labeled, while the rest are grouped with no table label. Sampled every 1800 seconds. After sampling, data is not visible for up to 10800 seconds. |
| google_bigquery_storage_table_count | bigquery.googleapis.com/storage/table_count | Table count | count | Number of tables. Sampled every 1800 seconds. After sampling, data is not visible for up to 10800 seconds. |
| google_bigquery_storage_uploaded_bytes | bigquery.googleapis.com/storage/uploaded_bytes | Uploaded bytes | bytes | Uploaded bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |
| google_bigquery_storage_uploaded_bytes_billed | bigquery.googleapis.com/storage/uploaded_bytes_billed | Uploaded bytes billed | bytes | Uploaded bytes billed. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |
| google_bigquery_storage_uploaded_row_count | bigquery.googleapis.com/storage/uploaded_row_count | Uploaded rows | count | Uploaded rows. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |
GCP BigQuery Table
| OpsRamp Metric | Google Metric | Metric Display Name | Unit | Description |
|---|---|---|---|---|
| google_bigquery_storage_stored_bytes | bigquery.googleapis.com/storage/stored_bytes | Stored bytes | bytes | Number of logical bytes stored. The top 100 tables in a dataset are labeled, while the rest are grouped with no table label. Sampled every 1800 seconds. After sampling, data is not visible for up to 10800 seconds. |
| google_bigquery_storage_uploaded_bytes | bigquery.googleapis.com/storage/uploaded_bytes | Uploaded bytes | bytes | Uploaded bytes. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |
| google_bigquery_storage_uploaded_bytes_billed | bigquery.googleapis.com/storage/uploaded_bytes_billed | Uploaded bytes billed | bytes | Uploaded bytes billed. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |
| google_bigquery_storage_uploaded_row_count | bigquery.googleapis.com/storage/uploaded_row_count | Uploaded rows | count | Uploaded rows. Sampled every 60 seconds. After sampling, data is not visible for up to 21720 seconds. |