Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 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
  • Anonymous's avatar
    Anonymous
    8 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
Icon for Super User rankSuper User
8 months ago

Hello Anonymous 

 

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! 
 
 
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 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
      Icon for Super User rankSuper User
      8 months ago

      Hi Anonymous  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
       
      • Anonymous's avatar
        Anonymous
        Not applicable
        8 months ago

        Hi deborshi_nag , I have imported the modules.