How to export data as a CSV file from a Hasura database?

Question

I have a few tables in the database in a Hasura cluster. I want to export one them as a CSV file (with the data). How can I do this?

2 revs · Accepted Answer · 2018-03-27 10:27:30Z

4

You can follow one of the following methods:

Connect to the database and use psql to export data as CSV:

a) Directly access the underlying Postgres db instance:

hasura microservice port-forward postgres -n hasura --local-port 6432

b) follow this SO question to actually export data as a CSV file (assumes you have psql installed).
Use the data APIs to write a simple service that can convert JSON to CSV and save it to a file.
If the size of the table isn't huge, you can also just use the api-explorer UI (either the Data section or the SQL interface) to display all the rows and copy & paste them into a file. It's pretty straightforward to convert this file into CSV format.

edited Mar 27, 2018 at 10:27

community wiki

2 revs
sandip

Sign up to request clarification or add additional context in comments.

Comments

Mo_ · Accepted Answer · 2025-11-06 19:42:24Z

4

Hasura exposes an API endpoint for accessing pg_dump of the underlying database:

curl --location --request POST 'https://<hasura-hostname>/v1alpha1/pg_dump' --header 'x-hasura-admin-secret: <password>' --header 'Content-Type: application/json' --data-raw '{  "opts": ["-O", "-x", "--schema", "public", "--schema", "auth"],  "clean_output": true}' -o backup.sql

edited Nov 6 at 19:42

Mo_

2,0701 gold badge12 silver badges33 bronze badges

answered Dec 8, 2020 at 10:30

Rodrigo Ribeiro

2693 silver badges8 bronze badges

Collectives™ on Stack Overflow

How to export data as a CSV file from a Hasura database?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related