Hi team, quick question: How do I use parameters from my local/credentials.yml file in my base/catalog.yml file? For example,

#credentials.yml

win_user: 'user01'

#catalog.yml

data:

type: pandas.ExcelDataSet

filepath: C:\Users\${win_user}\data.xlsx

Credentials are not designed to work this way.

${win_user}

in your case is related to the path, not credentials. If you need to interpolate the path, based on some variable, you can use globals.

And a

TemplatedConfigLoader

(or I think a

OmegaConfigLoader

) in your

settings.py

file

(And, for the standard/supported use of credentials in configuration, see https://docs.kedro.org/en/stable/data/data_catalog.html#feeding-in-credentials)

TemplateConfigLoader

worked, thanks! https://docs.kedro.org/en/stable/kedro.config.TemplatedConfigLoader.html

If you can read the win_user programatically, then use this https://kedro-org.slack.com/archives/C03RKP2LW64/p1676881692806879?thread_ts=1676863743.414139&cid=C03RKP2LW64