Amazon Redshift Advisor
Amazon Redshift Advisor was launched in mid 2018. It runs daily and continuously observes the workload's operational statistics on the cluster with its lens of best practices. Amazon Redshift Advisor uses sophisticated algorithms to provide tailored best practice recommendations, which allows us to get the best possible performance and cost savings. The recommendations are provided which is ranked by order of impact. Amazon Redshift Advisor eases administration. Some of the recommendations include the following:
- Optimization for the
COPY
command for optimal data ingestion - Optimization for physical table design
- Optimization for manual workload management
- Cost optimization with a recommendation to delete a cluster after taking a snapshot, if the cluster is not being utilized
Along with the Advisor recommendation, the Automatic Table Optimization feature allows you to apply these recommendations via an auto-requiring administrator...