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:
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:
- Vacuuming for Table Performance
- Monitoring Disk Space
- Monitoring Query Performance
- 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.