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?

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?

Fabrizio@AWS 전문가
2년 전
just to confirm: have you checked if the Redshift DataSource is using the User you expect for the connection?

주제

분석

태그

분석 아마존 QuickSight 아마존 Redshift

언어

English

faizulhaque

질문됨 2년 전797회 조회

1개 답변

최신
최다 투표
가장 많은 댓글

이 답변이 도움이 되었나요?커뮤니티가 여러분의 지식을 활용할 수 있도록 정답을 찬성하세요.

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.

지원 엔지니어

Chaitanya_T

답변함 2년 전

QuickSight SPICE Refresh failed with permission denied

관련 콘텐츠