I would appreciate some troubleshooting assistance...
# questions
g
I would appreciate some troubleshooting assistance. I have read these instructions: https://docs.kedro.org/en/stable/data/data_catalog.html#dataset-access-credentials I have a
conf\local\credentials.yml
which contains:
Copy code
dbname:
    con: "<postgresql+psycopg2://FOO:BAR@BAZ/BIN>"
And in my catalog:
Copy code
datasetname:
    type: pandas.SQLQueryDataSet
    credentials: dbname
    filepath: /path/to/meow.sql
But I am getting an error when I run the project.
DatasetError: Failed while loading data from data set SQLQueryDataSet(execution_options={}, filepath=path/to/meow.sql, load_args={}, sql=None). dict is a not a sequence.
Is this a bug? Or (more likely) how have I misunderstood the setup of credentials?
a
Try dbname.con?
n
What happen if you comment the credentials line? The error does not seem to related but just am not sure