By using AWS re:Post, you agree to the Terms of Use
/QuickSight SPICE Refresh failed with permission denied/

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?

  • just to confirm: have you checked if the Redshift DataSource is using the User you expect for the connection?

1 Answers

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.

answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions