Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Hi,
I need to set an automatic update of some date variables (the update is going to be recursive; each month it is going to add a month), which then will be used in a SQL receipts flow.
At the moment my solution is to create a date variable (dictionary containing the desired dates) and a Python script (inside a Python Notebook) that perform the update of the element of the dictionary, giving as output a dictionary of updated dates (formatted as unicode and so which can be used in the SQL receipt). I will then run the script and the SQL flow in a scenario, running each month.
The only thing I am missing is how to save back the dictionary into a project variable, inside the Python script.
Does such a function exist? Am I using a correct strategy?
Thank you very much for your help.
Regards,
Alessandro
Hi,
Assuming that you want to update the variable "stuff" in your project, use the following code:
import dataiku
client = dataiku.api_client()
project = client.get_project("MYPROJECT")
variables = project.get_variables()
variables["standard"]["stuff"] = "my new value for stuff variable"
project.set_variables(variables)
Hi,
Assuming that you want to update the variable "stuff" in your project, use the following code:
import dataiku
client = dataiku.api_client()
project = client.get_project("MYPROJECT")
variables = project.get_variables()
variables["standard"]["stuff"] = "my new value for stuff variable"
project.set_variables(variables)
Thank you very much; it worked and I got the update I was looking for.
Kind regards,
Alessandro
Hi, your solution works in python recipe. Can you please suggest me the same solution in SQL recipe?
how can i find the value of "my new value for stuff variable"?