# Connect Quicksight to Redshift with IAM

**URL:** <https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890>\
**Category:** Q&A\
**Tags:** redshift, data-source, Business-Intelligence-Engineer, quick-sight\
**Created:** [June 4, 2024, 1:38pm UTC](https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890 "2024-06-04T13:38:48Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![stevegup](https://avatars.discourse-cdn.com/v4/letter/s/e19b73/32.png) [@stevegup](https://community.amazonquick.com/u/stevegup)\
**Post date:** [June 4, 2024, 1:38pm UTC](https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890/1 "2024-06-04T13:38:48Z")

</div>

I am trying to connect Quicksight to Redshift via an IAM role. I was following the guide here, [Run queries as an IAM role in Amazon QuickSight - Amazon QuickSight](https://docs.aws.amazon.com/quicksight/latest/user/datasource-run-as-role.html)  
and [https://www.youtube.com/watch?v=LOOu7KOb7NA](https://www.youtube.com/watch?v=LOOu7KOb7NA)

I seem to be getting stuck when trying to run the create-data-source command with a 302 error. The error message in the cli doesn’t really say much else. I don’t see an option to create a redshift connection from the console except with the uid and pw.  
Wondering if there are any other documentation resources available.

---

<div class="post-metadata">

**Author:** ![WLS-DM](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/wls-dm/32/36109_2.png) [@WLS-DM](https://community.amazonquick.com/u/WLS-DM)\
**Post date:** [June 5, 2024, 3:27pm UTC](https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890/2 "2024-06-05T15:27:00Z")

</div>

Hello @stevegup, welcome to the Quick Sight community!

I was looking through the documentation that you linked in your post and I was wondering, are you trying to establish the connection using the Public network connection type, or a VPC connection?

My initial thought is the permissions are not established on Redshift to allow Quick Sight to access the data. I’ll link some documentation for that below. With a little more information, I can help guide you further. Thank you!

> **[Authorizing connections from Amazon QuickSight to Amazon Redshift clusters -...](https://docs.aws.amazon.com/quicksight/latest/user/enabling-access-redshift.html)**
>
> Configure Amazon Redshift clusters so that Amazon QuickSight can connect to them.

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 10, 2024, 2:14pm UTC](https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890/3 "2024-06-10T14:14:06Z")

</div>

Did this solution work for you? I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to [open a support case](https://docs.aws.amazon.com/awssupport/latest/user/case-management.html). If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!

---

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [June 10, 2024, 2:14pm UTC](https://community.amazonquick.com/t/connect-quicksight-to-redshift-with-iam/30890/4 "2024-06-10T14:14:38Z")

</div>

Archived on June 10, 2024, 2:14pm UTC


