Join the Kedro community

Updated 2 months ago

Credentials inserted into dataset configuration causing connection string errors

Hi all! I have an issue with credentials not being inserted into the dataset configuration:

credentials.yml
my_connection_string: "<connection>"<br /><br />catalog.yml<br />table1:<br /> type: pandas.CSVDataSet<br /> filepath: <a target="_blank" rel="noopener noreferrer">abfs://my_container/table1.csv</a><br /> credentials:<br /> connection_string: my_connection_string<br /><br />I get "unable to connect to account for Connection string is either blank or malformed.." errors. I guess "my_connection_string" is used as the connection string not "<connection>".

N
P
3 comments

can you change it to credentials: my_conneciton_string instead?

if i understand correctly, this is what you need:

# credentials:

my_connection_string:
  connection_string: <actual_connection_string> # Assuming connection string is the actual name of the argument

# catalog.yml

<some_data>:
  ...
  credentials: my_connection_string

Thanks so much. I did not realize that the replacement only works for top level keys.

Add a reply
Sign up and join the conversation on Slack