My use case:
I have multiple user groups in my system and I wanted to restrict the data access based upon the user group since the data source is the same for all users (S3 via Athena).
I was thinking if I can get the user group in my query so that I can use the same while querying. Is this feasible to do, if yes, can you explain how to do it?
Also is there any better way to achieve this?