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, 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! ![]()
Can you please share your timestamp, so I can take a closer look for you?
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.
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:
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! ![]()