How to Dynamically Filter Data for Individual Users Without Using Row-Level Security (RLS)

Question & Answer
,
1

I’m working on a QuickSight dashboard and want to ensure that each user sees only their own data without needing to create multiple dashboards. I do not want to use Row-Level Security (RLS). Instead, I’m looking for a way to dynamically filter the dashboard based on a user names, user emails and/ or user’s ID, such that when they access the dashboard, it automatically shows only their data.

Is there a way to achieve this in QuickSight without relying on RLS?

2

Hi @Ivanm,

You can do this by using parameters and dynamic default values. For example, if you want to filter by email address, create a parameter for it and link it to your filter. Assign a dynamic default value which is equal to the reader’s email address. If you don’t add a control for the parameter, the reader won’t be able to change the filter.

3

Hi @Ivanm,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @Ivanm,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!