I don t know what I did to my environment but I m now gettin

Question

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`

datajoely · Answer

Hi < RRoger> 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

datajoely · Answer

https github com quantumblacklabs kedro blob main setup py

datajoely · Answer

I think you may be looking for the following arguments it s safest to stick to the full and correct case sensitive names `pandas SQLQueryDataSet` `yaml YAMLDataSet` `pandas JSONDataSet` returns a df If you only want `json JSONDataSet` returns a dict you don t need an optional dependency

RRoger · Answer

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

datajoely · Answer

Thanks for following up

datajoely · Answer

Hey < RRoger> and these instructions don t help https kedro readthedocs io en latest 09 development 02 set up pycharm html configuring the kedro catalog validation schema

RRoger · Answer

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

datajoely · Answer

Okay

datajoely · Answer

so I don t have PyCharm on my machine

datajoely · Answer

but I think project root is a specific option you can set in the sidebar tree panel

datajoely · Answer

https www jetbrains com help pycharm configuring project structure html

datajoely · Answer

I wonder if that s the issue somehow

datajoely · Answer

Maybe this step is needed

RRoger · Answer

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

datajoely · Answer

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