Export results of SQLs from Heroku using Data Clips

By: Varghese Chacko 1 year, 10 months ago

Heroku comes with nice database backup tools, both commandline and web based. But how to export results of an SQL query?

Heroku provides Data Clips. Data clips are a web interface for heroku database. To create a dataclip, go to Data Clicp dashboard at https://dataclips.heroku.com/ You can logiin with your heroku username and password. On dashboard, click "Create Data Clip"

Then type in a name to identify the data clip, select the database and enter SQL in the sql's fild.

Click create data clip

Done. Your dataclip is ready

On top tight, the dropdown menu allows us to export to XLS, CSV and JSON, tweet to twitter and share via Google drive. The URL in the text box could be sent to anyone, to see the data.

Under settings, you can set different attributes and permissions. For Hoby plans, the data clip is publicly viewable

Data clip returns up to 100,000 rows of data.

Let us talk!

We take the vision which comes from dreams and apply the magic of science and mathematics, adding the heritage of our profession and our knowledge to create a design.