Forum Discussion

Abinaya95's avatar
Abinaya95
Frequent Visitor
1 year ago
Solved

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 ca...
data engineering
Lakehouse
Notebook
  • v-achippa's avatar
    v-achippa
    1 year ago

    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

v-achippa's avatar
v-achippa
Community Support
1 year ago

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's avatar
Abinaya95
Frequent Visitor
1 year ago

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?