Amazon QuickSight now supports running queries as an IAM role for Redshift data sources

https://aws.amazon.com/about-aws/whats-new/2023/10/amazon-quicksight-queries-iam-role-redshift-data-sources/