Discover this year's submissions to the Dataiku Frontrunner Awards and give kudos to your favorite use cases and success stories!READ MORE

Dataiku DB tables suffix with userid (dataiku userid)

jaganadhg
Level 1
Dataiku DB tables suffix with userid (dataiku userid)

Hi Team,

I am trying to suffix the dataiku recipe generated tables with user suffix.

I tried the variables ${User} and ${user}. There was no luck. Is there any standard way to achieve the same.

Cheers

Jagan

0 Kudos
1 Reply
Liev
Dataiker Alumni

Hi @jaganadhg 

If you don't mind expanding on the reason(s) to do this.

Assuming you're in your own environment the user is always you. In a shared environment, with several users sharing a project, such an approach would negate the collaboration, as each time the recipe is executed it would be potentially creating new tables in the database.