Programmatically change database for heroku dataclips

Question

We just upgraded our Heroku postgres database using the follower changeover method. We have over 50 dataclips attached to the old database, and now we need to move them over to the new database. However, doing them one by one will take a lot of time.

Is there a programatic way to update the database a dataclip is attached to, perhaps with the CLI tools?

Answer 1

At least once the old database has been deprovisioned, you can now (as of March 2016) reattach them to another database:

Go to https://dataclips.heroku.com/clips/recoverable. It will display your old database and a set of 'orphaned' dataclips and you can choose to transfer them to another database (in my case the promoted follower from the changeover).

Note that this only affects the dataclips that you created, it does not affect the dataclips one of your team members created and that you only had access to. So they will have to go through this process as well.

Official devcenter article: https://devcenter.heroku.com/articles/dataclips#dataclip-recovery

Answer 2

Thanks to Heroku CSRF measures, programmatically updating data clips is much more difficult than you might expect. You'll need to suck it up and start clicking buttons by hand, or beg their support team to do it for you, which is just as difficult.

---

There is no official support for programmatically moving the dataclips. That being said, you can script it out against their HTTP API.

The base URL is https://dataclips.heroku.com/api/v1/. There are three relevant endpoints:

• clips /clips
• resources (databases) /heroku_resources
• move clip /clips/:slug/move

Find the slug of the clip you want to move, find the resource id of the new database, and make a post to the move clip endpoint:

POST /api/v1/clips/fjhwieufysdufnjqqueyuiewsr/move
Content-Type: application/json

{"heroku_resource_id":"[email protected]"}