QuickSight SPICE Refresh failed with permission denied

0

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?

asked 2 years ago764 views
1 Answer
0

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.

SUPPORT ENGINEER
answered 2 years 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