RRoger
12/21/2021, 4:42 AMClass `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
12/21/2021, 10:55 AMkedro[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 depspandas.SQLQueryDataSet
yaml.YAMLDataSet
pandas.JSONDataSet
(returns a df)
If you only want
json.JSONDataSet
(returns a dict) you don't need an optional dependencyRRoger
12/23/2021, 3:41 AM...?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-875686559datajoely
12/23/2021, 12:03 PMRRoger
12/23/2021, 9:24 PMdatajoely
12/23/2021, 9:27 PMRRoger
12/23/2021, 10:17 PMgithub.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
12/24/2021, 11:34 AM