Query Times Optimizations with AQUA

Opportunity Name:

Enable Advanced Query Accelerator (AQUA) for Amazon Redshift

AWS Resource Type:

Amazon Redshift

Opportunity Description:

AWS introduced AQUA, which brings a storage-attached compute layer in the form of custom FPGA hardware with on-board SSD. The layer is transparent to the casual user. Redshift sends some queries (typically large scans and aggregates involving similarity and predicate filtering) to the AQUA layer, which can process these 10x faster using high speed parallel connectors to Redshift managed storage. This results in a better query performance and would eventually help rightsize the cluster if the sizing is driven by these accelerated queries.

Finder Criteria:

CloudFix checks for the Redshift Clusters with node type ra3.16xlarge or ra3.4xlarge in the below regions  with release version greater than 1.0.24421 that don't have AQUA enabled:

  • US East (N. Virginia) Region (us-east-1)
  • US East (Ohio) Region (us-east-2)
  • US West (Oregon) Region (us-west-2)
  • Asia Pacific (Tokyo) Region (ap-northeast-1)
  • Europe (Ireland) Region (eu-west-1)

Fixer Execution:

For the eligible Redshift Clusters that are found, CloudFix goes ahead and activates AQUA for those clusters.

Potential savings:

For the AQUA enabled Redshift Clusters, the performance of queries that perform large scans, aggregation, and filtering (with LIKE and SIMILAR_TO predicates) can improve up to 10X. Thus, AQUA is more of a performance enhancement than a cost-saver. The CloudFix change request will estimate a nominal $1 annual saving as there is also no additional cost to using AQUA.

Can CloudFix implement the fix automatically once I accept the recommendation?

Yes, for each eligible Redshift Clusters, CloudFix will enable AQUA on them.

Is it possible to roll back once CloudFix implements the fixer?

No, it's not possible to rollback the fix from CloudFix once it's enabled for a cluster.

Does this fix require downtime?

Getting the performance benefit from AQUA involves a cluster restart. To avoid disruptions, CloudFix does not do any cluster restart, but only activates AQUA. When you restart your cluster, you will see improved performance of AQUA-enabled queries.

Do it yourself (DIY) Instructions:

If you have a CloudFix subscription, CloudFix will execute these performance improvements for you. However, if you'd like to do it yourself - please follow the instructions for enabling AQUA.

Finding cost-saving recommendations with CloudFix is FREE! You'll need a paid subscription only if you'd like CloudFix to execute those recommendations.
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request