Submit your inspiring success story or innovative use case to the 2022 Dataiku Frontrunner Awards! ENTER YOUR SUBMISSION

use structured dataiku variables on dataset configuration

CamilleGui
Level 1
Level 1
use structured dataiku variables on dataset configuration

Hello everyone, 

Currently I use variables to define in which GCP projects and datasets the source tables are located.
As there are several times a "project" variable and a "schema" variable I would like to structure this via dictionaries.

Problem: I can't use them in the dataset configurations. Is it possible to use structured variables in the dataset configuration? Or is it only possible in python?

Indeed, in python I can get information :

import json
print(json.loads(dataiku.get_custom_variables()['schema'])['mido'])

 

Thanks for your help.

 

0 Kudos
1 Reply
SarinaS
Dataiker
Dataiker

Hi @CamilleGui,

Unfortunately variable expansion does not support nested/structured variables. You can unnest variables in Python as you've shown here, or in the DSS formula language. For the UI including dataset configurations you would need to use unnested variables.   

Thanks,
Sarina

0 Kudos