Looking for a way to export GCP Datastore entity data into csv file

Question

I would like to export data from a specific GCP Datastore entity (kind) into a CSV file. I would have thought that the gcloud or gsutil CLIs would be able to handle this but I haven't found a way as yet. Any recommendations?

Thanks

Answer 1

There's no out-of-the-box functionality to export Datastore entities directly in csv format.

A possible workaround you may follow is:

• Export the specific kind data to a Cloud Storage bucket with the following gcloud command

  gcloud datastore export --kinds="KIND" gs://your_bucket

• Import your Datastore export into BigQuery

• Export the BigQuery table as a csv file