CODEWITHSUNDEEP
google-cloud-platformgoogle-cloud-datastore
john mich
john mich

Reputation: 2873

How to Visualize JSON data present in google datastore using Data-Studio Tool?

I was exploring the Data-Studio tool of google cloud which helps in data visualization, but I think that this tool can only be used for SQL data visualization. How can I visualize JSON data present in my datastore using Data-Studio?

Is there any other tool present which can integrate my google datastore and help me visualize this JSON data?

Upvotes: 1

Views: 940

Answers (1)

Jofre
Jofre

Reputation: 3898

There is no direct connector to Datastore, but you can use this more or less convoluted path for visualizing this data: Datastore -> Storage -> BigQuery -> Datastudio

Let me break this down step by step:

  1. Export the entities:

    First we need to use the export utility from Datastore to extract the data from Datastore. This will generate a file in Google Cloud Storage.

  2. Import into BigQuery

    Then we can import the export file into BigQuery, or use it directly as an external data source.

  3. Connect to Datastudio

    Once we can access the data through BigQuery, it can be added as a source in Dtastudio.

With a little bit of trickery and ingenuity, you can schedule Datastore exports periodically to the same file, and have that file as an external datasource in BigQuery, meaning that you can visualize the data updated with the periodicity configured in the scheduling of the exports, and you have to do nothing manually.

Upvotes: 2

Related Questions