Forum Discussion
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 :...
Hi Folks,
The same code is working now. I havent changed anything but now it is running. Seems to be something internal issue.
Hi chetanhiwale,
Do you configure the warehouse anywhere in the notebook?
//For warehouse
spark.conf.set("spark.datawarehouse.<warehouse name>.sqlendpoint", "<sql endpoint,port>")
and are you working with Spark Runtime 1.3? This is only available in runtime 1.3 according to the docs:
Spark connector for Microsoft Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn
I havent setup following the property as the same code worked for my colleage also I have runtime 1.3
spark.conf.set("spark.datawarehouse.<warehouse name>.sqlendpoint", "<sql endpoint,port>").