Amazon Redshift now supports table level restore
You can now restore a single table from an Amazon Redshift snapshot instead of restoring the entire cluster. This new feature enables you to restore a table that you might have dropped accidentally, or reconcile data from a table that you might have updated or deleted unintentionally. To restore a table from a snapshot, simply navigate to the “Table Restore” tab for a cluster and click on the “Restore Table” button.
You can now restore a single table from an Amazon Redshift snapshot instead of restoring the entire cluster. This new feature enables you to restore a table that you might have dropped accidentally, or reconcile data from a table that you might have updated or deleted unintentionally. To restore a table from a snapshot, simply navigate to the “Table Restore” tab for a cluster and click on the “Restore Table” button.
Note that you can restore a table only from a snapshot of an actively running cluster to the same cluster. In addition, the snapshot must be of a cluster with version 1.0.1036 or above. To learn more, see Restoring a Table from a Snapshot in the Amazon Redshift Cluster Management Guide.