topic Re: Query data from Fabric SQL DB using spark / python. in Data Engineering

Query data from Fabric SQL DB using spark / python.

chetanhiwale — Wed, 04 Mar 2026 08:36:16 GMT

Hi Folks,

I am trying to query data using Fabric SQL DB using python / pyspark. But I am not getting proper syntax to query. If anyone has , can someone share the syntax.

Thanks and regards.

Re: Query data from Fabric SQL DB using spark / python.

Tamanchu — Wed, 04 Mar 2026 09:01:58 GMT

Hi @chetanhiwale ,

You can query a Fabric SQL Database from a Spark notebook using JDBC. Here's a working example:

jdbc_url = "jdbc:sqlserver://<your-server>.database.fabric.microsoft.com:1433;database=<your-db>"

df = spark.read \
.format("jdbc") \
.option("url", jdbc_url) \
.option("dbtable", "dbo.YourTable") \
.option("authentication", "ActiveDirectoryInteractive") \
.load()
df.show()
Alternatively, if your SQL DB is in the same workspace, you can use the synapsesql connector:
df = spark.read.synapsesql("YourDatabase.dbo.YourTable")

Did this help?
Drop a kudo so others can find it !

😉

Re: Query data from Fabric SQL DB using spark / python.

chetanhiwale — Thu, 05 Mar 2026 08:13:52 GMT

Hi @Tamanchu ,
I tried both both options but they are not working for me. Have you tried to use MS-SQL python module by Microsoft

Re: Query data from Fabric SQL DB using spark / python.

Tamanchu — Thu, 05 Mar 2026 08:34:24 GMT

Hi @chetanhiwale,

If the JDBC and synapsesql approaches didn't work, you can try using pyodbc directly in a Fabric notebook:

Also, could you share the error messages you got with the JDBC and synapsesql methods? That would help narrow down the root cause.

Thanks!