1 Answer
- Newest
- Most votes
- Most comments
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.
answered 4 months ago
Relevant content
- Accepted Answerasked 2 months ago
- asked 4 months ago
- asked a year ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 months ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
Please accept the answer if it is useful.