Running S3, Athena, and Redshift Queries with an IAM Role: 2024 Amazon QuickSight Learning Series

If you are wondering about how to leverage data connectivity in QuickSight, this is for you! Learn how to run queries with your IAM role in Identity Center using Run as Role queries in S3, Athena, and Redshift.
Technical level: 100-200
Pre-requisites: account is integrated with IAM Identity Center and IAM roles are created.
Any questions on this topic can be answered through our QuickSight Community forum for this session here! community.amazonquicksight.co...
BLOG: Run Queries as an IAM Role in QuickSight
docs.aws.amazon.com/quicksigh...
Learn QuickSight: community.amazonquicksight.co...
Demos: democentral.learnquicksight.o...
Community: community.amazonquicksight.com/
**************************************************************************************************
Chapters
00:00 Session and presenter introduction
00:44 Agenda - Data connectivity in Amazon QuickSight
01:32 Amazon QuickSight product overview
04:10 Data connectivity architecture to Amazon QuickSight
05:58 QuickSight examples with connected data
06:42 Data connectivity - What is it?
07:22 Run as Role in Amazon QuickSight
09:49 How to deploy Run as Role in your organization
11:04 Use cases for Run as Role
13:21 IAM role requirements for S3, Athena, and Redshift
13:56 S3 with Run as Role setup steps
15:48 Demo: S3 Run as Role for QuickSight
17:30 Athena with Run as Role setup steps
18:39 Demo: Athena Run as Role for QuickSight
22:00 Redshift with Run as Role setup steps
24:37 Demo: Redshift with Run as Role for QuickSight
25:53 Closing remarks