Capture Employee ID

Question & Answer
,
1

Hi Team,

Good Morning !

We would like to know is there a way in Quick Sight to capture the Employee ID of the user who currently logged in and to use that employee id to filter the data from a data set?

means are there any session parameters available to use the employee id of the user? because to use the row level security , we have to built /create another table or view with all the details. Just we want to avoid creating this and want to use the session parameters if available.

Thanks in Advance,
Madhu K.

2

Hi @MadhuK – You can use dynamic parameter default feature which allows to specify the default setting for the parameters based on dashboard users/groups. Creating parameter defaults in Amazon QuickSight - Amazon QuickSight. Does this solve your usecase?

3

Hi,

Thank you For Sharing the information.

Our requirement is we have to restrict some fields that are coming from multiple tables based upon their country.

so while preparing the dataset model , could it be possible to pass the user session information (user name or user id) to the dataset.

ex: select x.name,x.country
from user_country x where x.country=

Thank you,
Madhu K.

4

Hi @MadhuK - Are you using embedded dashboards or directly accessing quicksight? Either ways, you will be able to configure dynamic default parameters by having dataset created with usernames and their corresponding default parameters as explained here.

You can also look at tag based RLS if you have embedded dashboard use case..

5

Hi awsvig,

Good Morning !

We don’t have any embedded dashboards. We are trying to Replace Cognos with AWS Quick Sight. As part of that We are looking for a feature that is there in Cognos (ie. session Parameters using which we can get the user info who currently logged into the Cognos).
In Similar manner Does AWS Quick Sight offers any built in Session Parameters to get the current user information?

Thanks,
Madhu K.

6

You can use Row Level Security with user-based rules to restrict access to a dataset.RLS

Let me know if this solves your usecase

7

[quote=“MadhuK, post:5, topic:45733”]
Hi awsvig & Debonisd,

Good Morning !

My ask is can we have any Quick Sight session parameters to leverage it to get the userid of user from the session details . instead of defining a new dataset with the username and his roles?

Thanks & Regards,
Madhu K.

8

In QuickSight, as @debonisd has written, this is achieved using RLS . The RLS dataset will contain user information and associated restriction on values in a column for a dataset . There is no concept of session parameters.

Kind regards,
Koushik