IssueTracker

Problem you have encountered:
We would like to monitor Bigquery table attributes through Cloud Monitoring Metrics, but we found out that there aren't enough to achieve it.

What you expected to happen:
We would like to have a GCP metric or metrics for BigQuery that allow the customer to request Table attributes information [1].

How this might work:

If possible, have a metric to analyze table attributes and provide data about them. If not, then it would be needed one metric for each attribute. In this environment needed attributes to have a metric would be:

  "numRows" (Number or rows per table)
  "numBytes"  (Number of bytes per table)
  "creationTime" (Time of when it was created)
  "lastModifiedTime" (Time of last change)

metric names could look like:

storage/num_rows
storage/num_bytes
info/creation_Time
info/last_Modified_Time

Other information (workarounds you have tried, documentation consulted, etc):

This cannot be achieved with Custom metrics [2] Monitored resource does not include BigQuery, so it wouldn't be feasible.
Currently there's metric storage/uploaded_row_count , but it ain't enough for the customer needs.

[1]: https://cloud.google.com/bigquery/docs/reference/rest/v2/tables#Table
[2]: https://cloud.google.com/monitoring/custom-metrics/creating-metrics#custom-metric-resources