Clay Icon
Join the Community
02 Support

How to Undo Deletions and Restore Previous Table Versions in Databases

Avatar of Mike F.Mike F.
Ā·6 months agoĀ·

Is there a way to undo an action or revert to a previous version of the table? My company URL column was dependent on another column and I deleted that column because I wanted the company URL column to be a raw URL column. When I deleted the column from the field where it says ā€œEnter Valueā€, it deleted a ton of of the URLs in this normalizedurl field, and then I lost a ton of the enrichment data that was a function of the normalizedurl column.

7 comments

  • Avatar of Channeled
    Channeled
    APP
    Ā·6 months agoĀ·

    Unfortunately, we do not have the ability to recover deleted columns. The columns would need to be re-created and the data would need to be re-fetched from its providers. For future reference, here's what can be recovered in Clay: ** Deleted tables: These can be restored from the "Trash" tab on the main workspace ** Deleted rows: These can only be recovered using the "Undo" option that appears in the bottom-right corner immediately after deletion Since your case involves deleted column data, you'll need to: 1. Re-create the necessary columns 2. Re-run the enrichments to fetch the data again If you need help recovering credits for this situation, please let us know more details so we can look into it with you.

  • Avatar of Channeled
    Channeled
    APP
    Ā·6 months agoĀ·

    Did that answer your question?

  • Avatar of Mike F.
    Mike F.
    Ā·6 months agoĀ·

    No, I didnā€™t delete the column, I just changed it and lost a ton of data

  • Avatar of Channeled
    Channeled
    APP
    Ā·6 months agoĀ·

    Looks like you're still looking for help. We're currently outside of our standard office hours (9 AM to 9 PM EST, Monday through Friday), so it may take a little longer for us to respond. If youā€™re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!

  • Avatar of Mike F.
    Mike F.
    Ā·6 months agoĀ·

    any fixes here?

  • Avatar of Bo (.
    Bo (.
    Ā·6 months agoĀ·

    Hi, Once that disappears, we can't retrieve the data since it's gone from the system. How many credits were used here? For future reference, before making significant changes, I'd recommend turning off the auto-update feature, making your changes, and then turning it back on when you're done. This prevents unexpected data loss when modifying dependencies. Also here's some quick guides Tips for saving credits Credits 101 Let me know if you need help with anything else!

How to Undo Deletions and Restore Previous Table Versions in Databases | Clay