Sharing Query Results with Dataclips
Last updated 10 August 2018
Table of Contents
Dataclips allow the results of SQL queries on a Heroku Postgres database to be easily shared. Simply create a query on dataclips.heroku.com, and then share the resulting URL with co-workers, colleagues, or the world. The recipients of a Dataclip are able to view the data in their browser or download it in JSON, CSV, XML, or Microsoft Excel formats.
Dataclips may be created on both hobby- and production-tier databases, including private plans.
From within the Dataclips dashboard, when logged in, click Create Dataclip.
Name your Dataclip, choose a database, and type your query into the area:
Click Create Dataclip.
Dataclips can be accessed in several formats:
Access each format by selecting the format from the Dataclips menu, or by appending the file format to the URL of the Dataclip.
The JSON endpoint is handy for prototyping APIs but should not be used as a replacement for a production API. The JSON endpoint also supports Cross-Origin Resource Sharing (CORS) on GET requests to a clip’s JSON URL.
Interacting with Dataclips
Dataclips provide the ability to access results in several formats.
Given an example Dataclip - https://dataclips.heroku.com/vgyygvzqtezwpmwpcmmjlluamjlk you could access it in several forms:
- The latest results in CSV by adding .csv to the URL
- The latest results in JSON by adding .json to the URL
- The latest results in XLS by adding .xls to the URL
When accessing a Dataclip through any means (HTML/CSV/JSON/XLS), it will immediately show the last available results.
The query will also be run again if the last results are older than 1 minute.
If viewing on the web, it will alert you if there is a new result set available.
Queries that take longer than 10 minutes to run are automatically cancelled.
When connecting your Dataclips to Google Docs, Google caches the clip on an hourly basis.
All dataclips are secured through URLs that are unique and difficult to guess. Standard, Premium and Enterprise tier databases also have the ability to secure Dataclips to a Heroku user account.
To configure security permissions for a Dataclip, from the Dataclip’s page click Settings, modify the security permissions and then click Save Permissions.
When a database is upgraded or migrated to a different database, for example as a result of upgrading, the Dataclips associated with the old database become orphaned and require recovery.
To recover these dataclips, go to the Dataclips listing and click Reattach them now in the red warning banner on the top of the page to navigate to your recoverable Dataclips. A list of orphaned Dataclips is shown, which can be assigned to the appropriate database.
- Dataclips may return up to 100,000 rows
- Dataclips can only be secured via authentication on Standard, Premium and Enterprise tier databases
- Dataclips will cancel queries after 10 minutes