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?

トピック

分析

タグ

分析 Amazon QuickSight Amazon 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

関連するコンテンツ