Based on the documentation this seems to be very limited in the queries it can accelerate, just LIKE and SIMILAR TO

https://docs.aws.amazon.com/redshift/latest/mgmt/managing-cl...