topic Re: Notebook connecting to SQL Server in Data Engineering

Notebook connecting to SQL Server

msprog — Tue, 16 Sep 2025 00:25:26 GMT

HEy

we have a onprem sql server. There is a gateway connection to the sql server.

Now i want to access this sql server via a pyspark notebook. How can i set up a connection to this please.

thanks

Re: Notebook connecting to SQL Server

lbendlin — Tue, 16 Sep 2025 01:12:23 GMT

Is that a Fabric notebook? What will you do next after connecting? Run a SQL query and load it into a dataframe?

Re: Notebook connecting to SQL Server

msprog — Tue, 16 Sep 2025 01:16:28 GMT

yeah Fabric notebook. I read atable and load into a dataframe.

Re: Notebook connecting to SQL Server

spencer_sa — Tue, 16 Sep 2025 10:28:17 GMT

One of the announced features at Fabcon Europe was connections coming to notebooks.

Re: Notebook connecting to SQL Server

msprog — Tue, 16 Sep 2025 11:34:18 GMT

do you have a link to the announcement please?

Re: Notebook connecting to SQL Server

spencer_sa — Tue, 16 Sep 2025 15:27:38 GMT

Justyna has just confirmed that notebook connections don't support On Premise yet.

Re: Notebook connecting to SQL Server

JibinSebastian — Tue, 04 Nov 2025 17:59:20 GMT

I am also facing the same issue, Could someone help me to get the solution

Re: Notebook connecting to SQL Server

v-hjannapu — Wed, 05 Nov 2025 04:32:00 GMT

Hi @JibinSebastian,

Right now, Fabric notebooks don’t support connecting to on-prem SQL Server through the gateway. That’s why you are not able to connect directly from PySpark notebook.

Regards,
Community Support Team.

Re: Notebook connecting to SQL Server

JibinSebastian — Thu, 06 Nov 2025 13:56:53 GMT

@v-hjannapu
Thank you so much for responding. It helps a lot. Will keep in touch

Re: Notebook connecting to SQL Server

apturlov — Fri, 07 Nov 2025 20:49:26 GMT

@msprog @JibinSebastian You might be able to create a Mirrored SQL database from the on-premise SQL server using an OPDG (on-premise data gateway). It's realtively easy to try but when you are configuring the mirrored database you'd need to use a SQL server account with the admin permission so it can configure CDC. Once the mirroring is working you can create a shortcut to tables in a Lakehouse and now you have full access to the mirrored data from a Notebook.

Re: Notebook connecting to SQL Server

JibinSebastian — Mon, 10 Nov 2025 14:33:55 GMT

Thank you @apturlov for your response and efforts, I will try connecting with Mirrored SQL database into the fabric.