topic Synapse SQL connector for warehouse failed to write data. in Data Engineering

Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Mon, 19 Jan 2026 06:31:27 GMT

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 : I am already imported the modules.
The same code works for my colleague, but not for me. The same code created a new table in Warehouse without any warning or error.

Re: Synapse SQL connector for warehouse failed to write data.

BalajiL — Mon, 19 Jan 2026 05:43:09 GMT

pls check your schema in table and dataframe are equal.

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Mon, 19 Jan 2026 06:29:47 GMT

Hi, @BalajiL The schema and dataframe schema are same.

Re: Synapse SQL connector for warehouse failed to write data.

BalajiL — Mon, 19 Jan 2026 06:48:42 GMT

I dont think your schema will be same in df and table.

Make sure your table 'ok' has integer type for column id. Then execute the below code it should able to execute in warehouse.

import com.microsoft.spark.fabric

from com.microsoft.spark.fabric.Constants import Constants

from pyspark.sql.types import StructType, StructField, IntegerType

schema = StructType([

StructField("id", IntegerType(), True)

])

data = [(1,),(2,),(3,)]

df = spark.createDataFrame(data, schema)

Re: Synapse SQL connector for warehouse failed to write data.

deborshi_nag — Mon, 19 Jan 2026 11:18:14 GMT

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!

Re: Synapse SQL connector for warehouse failed to write data.

tayloramy — Mon, 19 Jan 2026 14:59:36 GMT

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

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Wed, 21 Jan 2026 07:35:31 GMT

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>").

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Wed, 21 Jan 2026 07:38:22 GMT

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.

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Wed, 21 Jan 2026 07:40:04 GMT

HI @BalajiL ,
Both schemas are same. As the spark is not able to find the synapsesql connector, more or less it seems issue with Spark connector / Spark runtime not with the schema.

Re: Synapse SQL connector for warehouse failed to write data.

deborshi_nag — Wed, 21 Jan 2026 12:57:02 GMT

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

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Thu, 22 Jan 2026 05:18:22 GMT

Hi @deborshi_nag , I have imported the modules.

Re: Synapse SQL connector for warehouse failed to write data.

chetanhiwale — Thu, 22 Jan 2026 05:19:30 GMT

Hi Folks,

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

Re: Synapse SQL connector for warehouse failed to write data.

deborshi_nag — Thu, 22 Jan 2026 16:16:28 GMT

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