Check out Building a Data-Centric Culture at the ALMA Observatory on November 5th Read More

Define Project Variable through database table prior to execution of scenario

Level 3
Level 3
Define Project Variable through database table prior to execution of scenario
Hi,

We have created a generic Dataiku Project which need the variable to be updated in each run. Instead of opening Dataiku project and changing the variable parameter or creating the multiple scenarios with different parameters, we want the parameters to be stored in a redshift table and want to change the parameter in table everytime when we want to run the Dataiku project. Is it possible to setup the project variable of scenario by any script or sql code in same format as required by Dataiku Project ?
0 Kudos
1 Reply
Dataiker
Dataiker

Hi,



You can use the following code to edit the variable from a python recipe:




import dataiku
client = dataiku.api_client()

project = client.get_project("PROJECTKEY")
variables = project.get_variables()
print(variables)

variables["standard"]["foo"] = "bar"
project.set_variables(variables)
print(variables)
Mattsco
0 Kudos
Labels (3)