https://kedro.org/ logo
#questions
Title
# questions
a

Agnaldo Luiz

04/27/2023, 12:04 PM
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
m

marrrcin

04/27/2023, 12:23 PM
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.
👍 1
f

FlorianGD

04/27/2023, 12:24 PM
And a
TemplatedConfigLoader
(or I think a
OmegaConfigLoader
) in your
settings.py
file
👍 1
☝️ 2
d

Deepyaman Datta

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

Agnaldo Luiz

04/28/2023, 2:24 AM
Accident
@marrrcin The problem with
globals.yml
is that each user has a different win_usr
m

marrrcin

04/28/2023, 7:27 AM