Forum Discussion

chetanhiwale's avatar
chetanhiwale
Resolver I
6 months ago
Solved

Synapse SQL connector for warehouse failed to write data.

Hello,  I am trying to write a dataframe to Fabric Warehouse using SynapseSQL connector. Somehow it is throwing attribute error.  Is anyone facing the same issue.  Code Snippet : Note :...
data engineering
Notebook
  • chetanhiwale's avatar
    chetanhiwale
    6 months ago

    Hi Folks, 

    The same code is working now. I havent changed anything but now it is running. Seems to be something internal issue. 

deborshi_nag's avatar
deborshi_nag
Super User
6 months ago

Hello chetanhiwale 

 

Could you please try the following steps:

 

1. Set the append mode to "overwrite" by using df.write.mode("overwrite").synapsesql.

 

2. Is the warehouse you are writing to located within the same workspace as your notebook?

 

3. You mentioned that the code works for your colleague. Are they using the same workspace? If not, would you be able to check if their Fabric runtime matches yours?

 

Hope this helps - please appreciate bu leaving a Kudos or accepting as a Solution! 
 
 
chetanhiwale's avatar
chetanhiwale
Resolver I
6 months ago

Hi deborshi_nag , 
Both warehouse and notebook are in same workspace. Also I do have 1.3 runtime and tried with overwrite. But the issue still persists.

  • deborshi_nag's avatar
    deborshi_nag
    Super User
    6 months ago

    Hi chetanhiwale  make sure you have the following 2 lines in the same cell in your notebook. 

     

    import com.microsoft.spark.fabric
    from com.microsoft.spark.fabric.Constants import Constants
     
    • chetanhiwale's avatar
      chetanhiwale
      Resolver I
      6 months ago

      Hi Folks, 

      The same code is working now. I havent changed anything but now it is running. Seems to be something internal issue. 

      • deborshi_nag's avatar
        deborshi_nag
        Super User
        6 months ago

        Hi chetanhiwale if it is working can you mark it as resolved please?