Amazon Redshift announces Snapshot Isolation as the default for new cluster creates and restores

The article discusses a change being made by Amazon Redshift, where snapshot isolation will become the default database isolation level for provisioned clusters when creating new clusters or restoring from snapshots. However, existing provisioned clusters will remain unchanged unless explicitly changed.

Specifically, the article covers:

• Amazon Redshift offers two database isolation levels: serializable and snapshot
• Snapshot isolation allows for better performance by allowing more concurrent operations on the same table
• This change makes the experience consistent between provisioned and serverless Redshift clusters, which already use snapshot isolation by default
• Existing provisioned clusters will remain unchanged unless the isolation level is explicitly changed
• The change applies to all AWS regions where Amazon Redshift is available