Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on September 20, 2023 7:58AM
Likes: 0
Replies: 2
Hi,
I've tried to use now() function inside a recipe.
The idea was to be able to identify each run by its timestamp.
Now I realize inside a run now() can take several values, particularly considering it takes milliseconds or something.
Is there a way to have a single now() value for each recipe run, like now() in SQL.
(I'd use SQL recipe but at the moment I'm not allowed in that particular infrastructure).
What exactly are you trying to achieve? What's the requirement/goal?
Welcome to the Dataiku Community.
I'm not is a place to look at this in detail. Here are a few random ideas.
You might look at saving a now() as a local project variable and then re-using that previously saved variable for each row. Or see if there is already a variable that contains a run time for the recipe. This might be done as part of a senario.
Another thing you might try is to do some rounding of the data and time. Such that you get one value but the values would be different each time. This latter approach might be a good minimal viable option.
Or if you data is stored in a SQL database use an actual SQL recipe to get the behavior you are accustomed to.
I think in this case I might use the latter approach using a SQL recipie.