View Users' Saved Queries as Redshift Admin?

0

I am an admin of our Redshift cluster. Is there a way for me to view (unshared) queries that have been saved by my Redshift users - especially decommissioned ones? I am worried that following the departure of some colleagues (and old roles that have been swapped out by our IT team), we may have lost very valuable queries that were saved via Query Editor. I am aware that I can view SOME recent query history via tables like STL_QUERY but I've already discovered there's pretty much no overlap between Saved Queries and that content.

質問済み 3ヶ月前292ビュー
1回答
0

Hello William,

The saved queries in Query editor v2 are specific to the user who saves the query. You cant view these queries in any system table/views unless the queries are executed on the Redshift cluster. I would also recommend using SYS_QUERY_HISTORY to get all the key query metrics from a single view.

Please feel free to comment if you have any other questions.

AWS
エキスパート
回答済み 3ヶ月前

ログインしていません。 ログイン 回答を投稿する。

優れた回答とは、質問に明確に答え、建設的なフィードバックを提供し、質問者の専門分野におけるスキルの向上を促すものです。

質問に答えるためのガイドライン

関連するコンテンツ