How to show snapshot API response data in data-studio?

Question

I need to design and display a compute engine snapshot report for different projects in the cloud in data-studio. For this, I am trying to use the below Google Compute Engine snapshot-api for retrieving data.

https://compute.googleapis.com/compute/v1/projects/my-project/global/snapshots

The data may change everyday depending on the snapshots created from the disks. So the report should display all the updated data.

Can this rest-api be called directly from Google data-studio?

Alternatively, what is the best/simplest way to display the response in data-studio?

Answer 1

You can use a Community Connector in Data Studio to directly pull the data from the API.

Answer 2

Currently, their is no way to connect GCP Compute Engine (GCE) resource data or use the REST API in Data Studio. The only products that are available on connecting data from GCP are the following:

1. BigQuery
2. Cloud Spanner
3. Cloud SQL for MySQL
4. Google Cloud Storage
5. MySQL
6. PostgreSQL

A possible way to design and display a Compute Engine Snapshot Report for different projects in the Cloud in Data Studio is by creating a Google App Script (to call the snapshot REST API) with a Google Sheet, and then import the data into the sheet on Data Studio.

Additionally, if you have any questions in regards to Data Studio, I would suggest reviewing the following documents below:

• Data Studio Help Center
• Data Studio Help Community

EDIT: My apologies, it seems that their is a way to show snapshot API response data in Data Studio by using a Community Connector to directly pull the data from the API.