Is there a list of all the builtin variables like ${projectKey}, ${dssUserLogin}, etc

Hi @ecerulm
,

There isn't a single centralized list of which built-in variables will depend on the context ( job, scenario, webapp, notebook, etc.)

You can see variables available in specific recipes/scenarios e.g:

Priority of variables is explained in more detail here when variables expansion is supported: https://doc.dataiku.com/dss/latest/connecting/sql/snowflake.html#how-to-set-it-up
Recipe > Scenario > Project > User > Global ( instance)

You can always print all other variables available. You can use the datiaku API to see the difference from a notebook/recipe/scenario.

# get client
import dataiku
client = dataiku.api_client() 

#When running a job print available variables( excludes recipe variables)
print(dataiku.get_custom_variables())

# print instance global variables
global_variables = client.get_global_variables()
print(global_variables)


#project variables
project = client.get_project("PROJECT_KEY")
#there are standard + local project variables 
project_variables = project.get_variables()
print(project_variables)

#user properties 
user = client.get_user("user_id")
print(user.get_settings().get_raw()['userProperties'])

For a scenario, you can use the following to print all variables:

from dataiku.scenario import Scenario
import json
print(json.dumps(Scenario().get_all_variables(), indent=2))

For the case of the namespace, while all variables are expanded the built-in variables available will depend on the context.

You should opt for variables available in all contexts, including notebooks and recipes. Otherwise, the containerized execution could not be both recipes and notebooks. The built-in variables jobProjectKey / jobId are NOT available in notebooks for example

The built-in variables you can use safely are projectKey and dssUserLogin. You can also use global variables user properties or project variables.

Thanks,