Forum Discussion
Unable to read table from Redshift using Fabric Notebook
I tried to read data from redshift and write the same in Fabric lakehouse. I have all the access and tried get the output using copy data activity but couln't able to retrieve from notebook. In my case i want to do that in notebook only. but it showing the jar file issue.
1st i used this jar file redshift-jdbc42-2.1.0.12.jar and got the error of
jar file issue like that and the reference from internet again i used the jar file as
I kept the jar file in lakehouse files and called the lakehouse inside the notebook. I referred by using ABFS path. The code I used to connect the redshift database is given below
If anyone having the solution to read the redshift table data from fabric notebook Kindly give a the solution in detail ASAP.
Thanks in Advance!!!
Hi Abinaya95,
Thank you for reaching out to Microsoft Fabric Community.
Microsoft Fabric currently does not support dynamically loading JDBC jar's using ABFS paths. The exception indicates that the Redshift JDBC jar is not found in the notebook's runtime class path.
Use the Copy Data activity from Redshift to fabric Lakehouse.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
3 Replies
Hi Abinaya95 Check out the below posts / articles and see if that helps
1. How to connect Amazon Redshift to python - Stack Overflow
2. How To Connect AWS Redshift to Python Notebook | by Abraham Setiawan | CodeX | Medium
Thanks,
Jai
Hi Abinaya95,
Thank you for reaching out to Microsoft Fabric Community.
Microsoft Fabric currently does not support dynamically loading JDBC jar's using ABFS paths. The exception indicates that the Redshift JDBC jar is not found in the notebook's runtime class path.
Use the Copy Data activity from Redshift to fabric Lakehouse.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thanks and regards,
Anjan Kumar Chippa
Is there anyway to read data from redshift using fabric notebook. I done the same to retrieve data from AWS S3 Files but why can't I do for this?
