Does Redshift creates snapshot in case of RENAME command?

0

Following this blog: https://docs.aws.amazon.com/redshift/latest/dg/c_serial_isolation.html, it states "A database snapshot is created within a transaction on the first occurrence of most SELECT statements, DML commands such as COPY, DELETE, INSERT, UPDATE". We have a requirement for Redshift snapshot isolation to create a snapshot also on RENAME commands. Is this supported? If not, how to approach this if we have concurrent transactions with RENAME commands.

1 Answer
1

The snapshots you see from the Redshift console are taken every 5 GB data change or 8 hours, whichever comes first. This is default setting for automated snapshots but you can increase the frequency to be every hour instead of 8 hours. The snapshots for SELECT statements and DML commands are internal snapshots, are invisible to you and are managed by Redshift internally. Also the RENAME command just executes a metadata update in the system tables. If you have specific requirements for snapshots above and beyond the automated snapshots then you will have to take manual snapshots to meet those requirements.

profile pictureAWS
answered a year 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