I have a dataset with Foundry user RIDs. I want to resolve to their username/email.
How can I translate those user RIDs to username/emails as part of a transform ?
Those user rid are populated via an Action, that creates objects, and that is then materialized as a dataset.
Sharing two possible approaches
- You can just pass the username / user info into the action as well. This will just enrich the dataset with it from the start.
- You can use the foundry api in an external transform to list all users, you can then join on user rid to pull in the other attributes. If you take this approach and are using python transforms, I’d recommend checking out the foundry sdk which should be helpful to fetch the usernames.