We started to use Quicksight as viable alternative to Tableau.
In internal communication, one of benefits over Tableau was the ability to use IAM based authentication for Datasource (Redshift) and discourage Tableau because it doesn’t support IAM authentication (again for embedded credentials).
However, when I create / edit my Redshift connection, I can only use username & password authentication.
Funnily enough, we were able to embed IAM based credentials on extract to Tableau server
I was able to find this documentation:
How can I know if this feature will be supported on our own account?
Note - I am not admin for our account, but as a creator, I am able to create new datasets from existing and new datasources.
Hi @dubravec - Welcome to AWS QuickSight and thanks for posting your question. Can you please follow the below steps for connecting Redshift from QuickSight using IAM authentication.
Note - If you are facing any issues, please let us know so that I can also try to explore it.
I will look on the resource, thank you. Unfortunately, I am not admin of our qs account, nor admin of our redshift cluster that sits in different aws account.
So I need to rely on either of these to implement the changes. Do both teams need to work on this?
I was discussing this within our teams and what I’ve head is that IAM authentication is possible only if Redshift and Quicksight are in single AWS account. Our Redshift Cluster and Quicksight account sit in different acct.
