In our business case, we want to give the access of Analysis to our customers. So that they could create and publish their own dashboards. This part we have already figured out. The next part is to give the authors department-wise access.
Our parquet files are stored in a S3 location which is queried through the Athena tables. Quicksight will be connected with the athena table as data set. Say the table has three columns as following
| id. | department | Name
|. 1. | Sales. | A
|. 2. | Marketing. | B
| 3. | Developer. | C
| 4. | Sales. | D
| 5. | Sales. | E
Now we want any author from a department should only get the access to the same department on the Analysis page to create his/her dashboard. Say if Author A is opening the Analysis page he/she should get row 1,4 and 5.
Initially we thought that the row-level security security could be our answer. But from the documentation we found that row level security is more for the readers directly on the published dashboard. Can anyone please help how exactly we can incorporate same row level security kind of use case for our authors also?