User attributes via an explore?

Within many of Looker’s pre-defined explores under “System Activity”, there’s a ton of useful dimensions and measures, but the user attributes don’t appear to be exposed anywhere. Is there a way to access those user attributes within an explore?

I know we can see them within User Admin, but we want to be able to display those user attributes in a dashboard.

ecbc661c-9bda-469e-9a58-af44f1533e79.png
Solved Solved
0 5 1,859
1 ACCEPTED SOLUTION

Hi @Ryan_PS,

Thanks for the post. There is an existing request with our product team for this feature: https://portal.feedback.us.pendo.io/app/#/case/49961 Please feel free to add the details of your use-case to the existing thread. This goes directly to our product and supportability teams. There is a workaround listed here: 

https://community.looker.com/general-looker-administration-35/auditing-user-attribute-values-with-an...

 I have seen a few other customers use in the past. Another potential option would be to create a derived table or column in your database with the values for given user attributes. Then, you could query them like a traditional dimension.

Please let us know if you have any questions.

Thanks

Eric

View solution in original post

5 REPLIES 5

Hi @Ryan_PS,

Thanks for the post. There is an existing request with our product team for this feature: https://portal.feedback.us.pendo.io/app/#/case/49961 Please feel free to add the details of your use-case to the existing thread. This goes directly to our product and supportability teams. There is a workaround listed here: 

https://community.looker.com/general-looker-administration-35/auditing-user-attribute-values-with-an...

 I have seen a few other customers use in the past. Another potential option would be to create a derived table or column in your database with the values for given user attributes. Then, you could query them like a traditional dimension.

Please let us know if you have any questions.

Thanks

Eric

Hi Eric,

Do you know if this product feature was ever addressed. The feedback link to Pendo requires a user account.

We now have a similar requirement. We use a whitelabeled version of looker embedded in our Saas platform, and we have a requirement to monitor looker usage per saas client (tenant) which is set as a user attribute on the embed SSO looker user. 

What we'd like to be able to do is use the existing User and Compliance User/Permission explores but group/pivot the data by the users tenant Attribute.

+1 also needed. Worried this is another "feature coming" that never comes to Looker

We also need this feature. 

I also desperately need this. 
I need this to govern the pii accesses.

Top Labels in this Space