How do I apply RLS to a dataset based on managerial hierarchy in quicksight?

[duncan]

Hello @Shivam , welcome to the Quicksight Community!

Would you be willing to attempt this with some SQL? If so I believe the solution below could be helpful for this type of hierarchy.

Row level security (SQL implementation) for user to see information of all employees reporting under them

Hello, I am looking to implement row level security using SQL custom query. I have the data flattened as: | employee_login | reporting_to_level_1 | reporting_to_level_2 | … | manager | | A | P | Q | … | C | | B | P | Q | … | C | | C | P | Q | … | D | | D | P | Q | … | E | Usually the reporting structure starts giving nulls from reporting_to_level_15. I have created CTE for self, peers, manager and direct reports. Then I union all the CTEs together to form the RLS dataset. Now, I want to e…

Let me know if this helps!