1

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?

2

Redash doesn’t support this but it would be useful. Ideally it would be possible to pass user credentials directly to the data source enabling row level security.