Solved: User attributes via an explore? - Page 2

Ryan_PS · 08-04-2021 03:39 PM

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.

Eric_Lyons

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