Snowflake has a wonderful feature that they call Time Travel. It allows you to replicate your table from its state in the past. We're happy to announce initial support for this great feature in Keboola Connection.
To begin with, every project with a Snowflake backend has been set to retain data history for 7days. That means that you can restore a table to how it existed at any point within the last week. It is possible to increase the data history retention period, so if you're interested in doing that please let us know by using the support button in your project
We've added this restoration method to the snapshots tab in the storage console:
Restoring a table is very simple, just use the calendar to pick the date and time, give the new table a name, and choose which bucket to put it in.
We plan on extending the use of this feature to be able to use time travel replicas as an input option for transformations and to create a "Storage Trash".
Happy travelling!