QuickSight SPICE Refresh failed with permission denied
In SPICE -> I have one simple query ag select * from <db>.public.<tableName>
and when I try to full refresh the spice it give me error as
sourceErrorCode: 500310 sourceErrorMessage: Amazon Invalid operation: permission denied for relation <tableName>; sourceErrorState: 42501 sourceException: java.sql.SQLException sourceType: REDSHIFT
FYI: I can perform the same query on query editor, it works fine. I also granted the full permission to my user using GRANT ALL PRIVILEGES ON ALL FUNCTIONS IN SCHEMA public to <userName>;
any help?
Thank you for posting your query, Please check your Redshift DataSource to confirm if the user you are using in the DataSource and the user that you have granted the privileges are the same. If you still have issues, please raise a ticket with AWS support so we can investigate further.
Relevant questions
Quicksight - Create data set (Athena) - Table query times out when trying to create data set
asked a month agoQuicksight Incremental Refresh for Modified records?
asked 6 months agoDate Format Errors when importing CSV file data from S3 to SPICE
asked 17 days agoAmazon Quicksight SPICE Data set partition
Accepted Answerasked 3 years agoQuickSight SPICE Refresh failed with permission denied
asked 5 months agoDo we have to Spice duplicate data?
Accepted Answerasked 2 months agoUnable to refresh QuickSight Dataset
asked 5 months ago"Spice Usage" much higher than expected and now full
asked a month agoQuicksight dataset SPICE refresh not loading data
asked 2 months agoAthena QuickSight query timesout
asked 5 months ago
just to confirm: have you checked if the Redshift DataSource is using the User you expect for the connection?