databasecsvexporthasura

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

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?

Solution

  • You can follow one of the following methods:

    1. 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).

    2. Use the data APIs to write a simple service that can convert JSON to CSV and save it to a file.

    3. 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.