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 個月前
- AWS 官方已更新 1 年前
Please accept the answer if it is useful.