We will create Iam role for services( Glue, QuickSight,etc.) need access data in S3, perform its action.
Go to IAM Role in AWS Console.
Click Create role.

Click Custom trust policy.
Trust QuickSight, Glue
{
"Version": "2012-10-17",
"Statement": [
{
"Effect": "Allow",
"Principal": {
"Service": "quicksight.amazonaws.com"
},
"Action": "sts:AssumeRole"
},
{
"Effect": "Allow",
"Principal": {
"Service": "glue.amazonaws.com"
},
"Action": "sts:AssumeRole"
}
]
}

Click next.
Add permission (like AdministratorAccess)
Click next until Review page.

Click Create role.
We will create Iam role for CloudFormation to create resource
Go to IAM Role in AWS Console.
Click Create role.

In AWS Service choose CloudFormation.
Click next.
Add permission (like AdministratorAccess)
Click next until Review page.
Click Create role.