1回答
- 新しい順
- 投票が多い順
- コメントが多い順
1
To get the number of queries executed by each IAM account in Amazon Redshift, you can query the STL_QUERY table. This table contains information about queries, including the user ID of the account that executed the query. By using the STL_QUERY table, you can track the number of queries executed by each IAM account. Here is an example SQL query to retrieve the number of queries executed by each IAM account:
SELECT userid, COUNT(*) AS num_queries FROM stl_query GROUP BY userid;
This query will provide the count of queries executed by each IAM account.
回答済み 4ヶ月前
関連するコンテンツ
- AWS公式更新しました 5ヶ月前
Please accept the answer if it is useful.