<kedro.io>.core.DatasetError: An exception occurre...
# questionsi
Irtiza Kaleem
03/05/2024, 7:25 PMkedro.io.core.DatasetError: An exception occurred when parsing config for dataset 'patient_base':
Class 'pandas.SQLQueryDataSet' not found, is this a typo?
d
Deepyaman Datta
03/05/2024, 7:26 PMDataSet -> Dataset
i
Irtiza Kaleem
03/05/2024, 7:27 PMThat was quick 🙂 Thank you for the response. Yes that worked.
🙌 1
Irtiza Kaleem
03/05/2024, 8:32 PMHi @Deepyaman Datta.
Irtiza Kaleem
03/05/2024, 8:33 PMI'm trying to run my script, but getting the following error:
Irtiza Kaleem
03/05/2024, 8:33 PM'OptionEngine' object has no attribute 'cursor'
Irtiza Kaleem
03/05/2024, 8:33 PMSeems some issue with the SQLAlchemy dialect maybe. I've tried the following:
redshift+psycopg2
redshift+redshift_connector
postgresql
Irtiza Kaleem
03/05/2024, 8:34 PMBut none of them work.
d
Deepyaman Datta
03/05/2024, 8:42 PMWhich version of pandas do you have?
i
Irtiza Kaleem
03/05/2024, 8:50 PM2.2.1
Irtiza Kaleem
03/05/2024, 8:51 PMAh. It worked. I downgraded to 2.1.3.
Irtiza Kaleem
03/05/2024, 8:51 PMThanks for the catch.
d
Deepyaman Datta
03/05/2024, 8:51 PMYeah, was about to suggest that
Deepyaman Datta
03/05/2024, 8:51 PMDeepyaman Datta
03/05/2024, 8:52 PMBut this should be handled by the dataset requirements, or we should update it to be compatible with 2.2+
👀 1