Overview

At Silota, Amazon's Redshift is our data warehouse of choice. As we've onboarded our customers to this amazing piece of technology, we've picked up some tips and tricks along the way that we're sharing here:

Maintenance

Though Amazon's marketing suggests that Redshift is a fully managed data warehouse, in our experience it requires ongoing maintenance to maintain its performance characteristics:

1. Vacuuming for Table Performance
2. Monitoring Disk Space
3. Monitoring Query Performance
4. Column Compression

Next Generation SQL Data Analysis Write SQL, visualize data, and share your results. Onboarding forward-thinking teams now:

No spam, ever! Unsubscribe any time. Learn more about the product.