Listing GCP metrics in a notebook

[PeteBush]

Hi, I want to use a notebook to list all the ingested GCP metrics in our tenant and organise the results by GCP product, for example... 

Spanner:

•  Metric 1
•  Metric 2

Apigee:

•  Metric 1
•  Metric 2

I've been searching for the right DQL to do this but struggling, the notebook AI is no help either. Is this possible in DQL or is there a better way to achieve this? Any pointers appreciated.

Thanks

Pete

[angelalanis]

Hi, you can use fetch metric.series to fetch metrics using DQL.

fetch metric.series
| filter matchesPhrase(metric.key, "cloud.gcp")

Maybe you can start with this query and you will be able to see more fields so you can get the result you want.

In this case, I'm filtering so it checks if the metric key contains "cloud.gcp". There are many fields you can use but I'm not too familiar with GCP.

I hope this was helpful!

[PeteBush]

Thanks this looks a great starting point, I'll explore what I can do from here. Appreciate the response, thank you.

[angelalanis]

Great! If you need more help, reply to this post 🙂