topic Re: Unable to read table from Redshift using Fabric Notebook in Data Engineering

Unable to read table from Redshift using Fabric Notebook

Abinaya95 — Fri, 23 May 2025 13:25:15 GMT

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

Re: Unable to read table from Redshift using Fabric Notebook

Jai-Rathinavel — Sat, 24 May 2025 19:06:28 GMT

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

Re: Unable to read table from Redshift using Fabric Notebook

v-achippa — Mon, 26 May 2025 13:01:12 GMT

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

Re: Unable to read table from Redshift using Fabric Notebook

Abinaya95 — Mon, 26 May 2025 14:52:42 GMT

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?