Parameter file for DB connections

@anthony
- sorry for the delayed response. I was thinking more or less exactly what @tgb417
mentioned in his post. If you are comfortable with code recipes you can build python code that will update the parameters using the REST API after each run. This is helpful if you know what you want to update your variables to. The limitation here is that the account running the recipe (and updating the variable) will need sufficient privileges to do so.

Minimally viable Python example of how to update the variables using code. Note: Here, I am manually deciding what to update the variables to (hard-coded). You will likely need an automated way (code based) to determine that for you (for example: get value of the last variable and increment by 1).

import dataiku
api = dataiku.api_client()      # API Client (will have permissions of the user who runs this code)

dss_variables = api.get_variables() # Scope = DSS (these are system variables across DSS, not the variables for the project)

# Get the current project
proj = api.get_default_project()      # Get the project within which we are running this code. Use api.get_project(<project_name>) method to use a different project
proj_variables = proj.get_variables() # Project variables

#{u'local': {u'local1': u'local1'}, u'standard': {u'global1': u'global1'}}   

new_proj_variables = variables.copy() # Create copy of the existing variables 

# Change the local variables
new_proj_variables['local']['local1'] = 'local2'          # Modify existing variable
new_proj_variables['local']['a_new_local_var'] = 14       # Add new variable
proj.set_variables(new_variables)                         # UPDATE the variables for this project

proj.get_variables()    # Fetch the New variables
# {u'local': {u'a_new_local_var': 14, u'local1': u'local2'}, u'standard': {u'global1': u'global1'}}