Does Redshift creates snapshot in case of RENAME command?
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.
- 最新
- 投票最多
- 评论最多
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.
