QuickSight SPICE Refresh failed with permission denied

Question

In SPICE -> I have one simple query ag select * from .public.

and when I try to full refresh the spice it give me error as

sourceErrorCode:	
500310
sourceErrorMessage:	
[Amazon](500310) Invalid operation: permission denied for relation ;
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 ;

any help?

Answer

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.

QuickSight SPICE Refresh failed with permission denied

Contenido relevante