Add username that ran query to Athena get_query_execution() response

alngrd commented 9 months ago

Describe the feature

When calling the get_query_execution() I get all the information possible about the query except for who ran it. Add the username/roleARN of the user who executed the query to the response of the get_query_execution() call.

Use Case

I'm trying to build a search system on all my companies query history on Athena and for that I need to know how ran each query. Without knowing the user I have no way of knowing if the query was on automatic job, which department it came from or who it can be beneficial to. In Google BigQuery it does return the user and it makes a lot of sense that this information will be available on Athena as well.

Proposed Solution

Add the username/user_email/RoleARN to response

Other Information

No response

Acknowledgements

[ ] I may be able to implement this feature request
[ ] This feature might incur a breaking change

SDK version used

1.34.19

Environment details (OS name and version, etc.)

Windows 10 pro

tim-finnigan commented 5 months ago

Hi @alngrd thanks for the feature request and for your patience. The Athena service team owns the GetQueryExecution API, so this feature request would need to get forwarded to them. Have you also tried Logging Amazon Athena API calls with AWS CloudTrail? Using CloudTrail you can find out more info on who ran API actions like StartQueryExecution:

github-actions[bot] commented 5 months ago

Greetings! It looks like this issue hasn’t been active in longer than five days. We encourage you to check if this is still an issue in the latest release. In the absence of more information, we will be closing this issue soon. If you find that this is still a problem, please feel free to provide a comment or upvote with a reaction on the initial post to prevent automatic closure. If the issue is already closed, please feel free to open a new one.

boto / boto3