Configuring Amazon Redshift Advisor for provisioned clusters
Amazon Redshift Advisor was launched in mid-2018. It runs daily and continuously observes the workload’s operational statistics on the data warehouse with the lens of best practices. Amazon Redshift Advisor uses sophisticated algorithms to provide tailored best practice recommendations, which enable you to get the best possible performance and cost savings. The recommendations are prioritized based on their severity level and potential impact on the system, which eases administration. Some of the recommendations include:
- Optimization of the copy command for optimal data ingestion
- Optimization of physical table design
- Optimization of manual workload management
- Cost optimization with a recommendation to delete clusters after taking a snapshot, if the cluster is not utilized
Along with the Advisor recommendations, the automatic table optimization feature allows applying these recommendations...
