Restore table to previous time stamp

Hi, I've accidentally deleted a very important table in a Retool database. Is there any way to restore the table to a previous time stamp? I understand from previous inquiries that it seems Retool support staff can help with this.

Thank you!

Hi @karsen, welcome to the Community, I’m here to help! :raised_hands:
Can you please share your timestamp, so I can take a closer look for you?

1 Like

Time stamp we would like restored is 10:00AM today (August 18). Would be great to DM to discuss more private details about table name, etc.

Thanks for waiting @karsen!

Created retool_db (production) recovery snapshot 2025-08-18T17:00:00Z! This resource is immediately accessible.

  • Resource identifier: 43433a20-d468-47ad-bab1-a90f2ab1b694
  • Expires 2025-08-25T17:00:00Z

Go to Resources and search for the snapshot mentioned in the reply above. Query the snapshot resource like any other PostgreSQL resource. Here are two ways you can recover your data:

  1. Create a short-lived app to transfer data from the snapshot resource to RetoolDB.
  2. Pull the data into the Query Library, export it to CSV, and import it through the Database UI.

Let me know if you are able to recover it!

Thank you! I can see this now, but the table is too large to easily do either of these. Any tips for pagination or another way I can do this?

Yes @karsen! The easiest way to paginate is by using offset in the queries. If you want to automate it, you can also set this up with workflows.

How’s it going? @karsen just a heads up that the recovery snapshot will expire in a week!

It worked! Thank you so much, and thank you for letting me know.

Wonderful, so glad I could help! Thank you for being here in the forum, and feel free to start another post anytime if you have other technical questions!

Additionally, we host Office Hours twice a week on Tuesdays and Thursdays from 11–12 PM PST. It’s a great chance to get live debugging help from the Retool team and other developers! :sunglasses: