Unable to read table from Redshift using Fabric Notebook

[Abinaya95]

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 

redshift-jdbc42-no-awssdk-1.2.55.1083.jar for this i got the error of 

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!!!

[v-achippa · Accepted solution]

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

[Abinaya95]

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?

[Jai-Rathinavel]

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