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.
Best answer by Eric_Lyons
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:
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.