Can I restore a table in RedShift and is it safe?

0

I want to restore a table that I deleted in RedShift production system. Is it possible and could it impact my production negatively?

AWS
AWS TAM
asked 2 months ago104 views
1 Answer
0
Accepted Answer

Yes, it is possible as mentioned in https://docs.aws.amazon.com/redshift/latest/mgmt/working-with-snapshots.html#working-with-snapshot-restore-table-from-snapshot

Please note that it is possible that when you restore a very large table, the RedShift cluster can consume most of the CPU on the restore operation and become unresponsive for other operations (like normal queries for other tables). There is need for a feature that allows cancelling this operation by the user. It would help to resolve the issue self-service without AWS support attention. This feedback has been relayed to the service team as well as improving the public documentation around this topic.

AWS
AWS TAM
answered 2 months ago
profile pictureAWS
EXPERT
reviewed 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions