Cannot create quick sight data source with a role

Q&A
,
1

I am trying to create athena data source with the following command line:

aws quicksight create-data-source –aws-account-id [account id] –data-source-id test –type ATHENA –name test

If i did that with my iam credential, it got created.

However, when i tried to do similar command line on my EC2 instance with a role ( that role got full access to quicksight and athena), it could not be created.

the error when i ran “describe-data-source” was

{“Type”: “ATHENA”,
“Status”: “CREATION_FAILED”,
“CreatedTime”: “2026-01-13T17:59:09.719000+00:00”,
“LastUpdatedTime”: “2026-01-13T17:59:10.175000+00:00”,
“SslProperties”: {
“DisableSsl”: false
},
“ErrorInfo”: {
“Type”: “ACCESS_DENIED”,
“Message”: “Not sufficient permissions are granted by your account administrator to access your other AWS resources.”
}

What permission i am missing ?

2

Hi @peterd

Ensure the EC2 instance role has the necessary Quick permissions, such as quicksight:CreateDataSource, and allows Quick to assume its service linked roles. Attach relevant IAM policies.

As a Quick administrator, go to Manage Quick → Security & permissions in the console, and verify or enable access to Athena (including query result locations in S3).

Please refer to the below Quick documentations and community post this might be helpful for you.

3

Hi @peterd

It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.

If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.

Thank you!

4

Hi @peterd

Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.

Thank you!