I don't know what I did to my environment, but I'm now getting

Class `pandas.SQLQueryDataSet` not found or one of its dependencieshas not been installed.

In

requirements.in

I have

kedro[pandas,pickle,yaml,json]==0.17.5

which should install all pandas DataSets right? I do

kedro build-reqs

then

pip install -r src\requirements.txt

.

Hi @User it is my understanding that

kedro[pandas]

should have installed all of those. However, if you're ever unsure the best place to really look is our

setup.py

file as that has all the real names of datasets we support as optional deps

I think the error was caused by a "mistake" in my database connection string. It was

...?driver=SQL+Server+Native+Client+11.0?trusted_connection=yes

(having more than one

?

), which worked in an older version of SQLAlchemy. I unknowingly updated the SQLAlchemy version, which doesn't accept strings with multiple

?

. I fixed it buy changing the subsequent

?

to

&

. https://github.com/sqlalchemy/sqlalchemy/issues/6727#issuecomment-875686559

Thanks for following up

Those are the instructions that I followed in the first place. No mention of how to deal with the error. No big deal though.

Okay

I found out what was causing it. It's a mistake on my part. I used the

github.com/...

link https://github.com/quantumblacklabs/kedro/blob/main/static/jsonschema/kedro-catalog-0.17.json instead of the link to the file itself, https://raw.githubusercontent.com/quantumblacklabs/kedro/develop/static/jsonschema/kedro-catalog-0.17.json.

Ah gotcha - we’re creating kedro.org at the moment, perhaps that’s a better place for this to live