Notebook connecting to SQL Server

[msprog]

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

[apturlov]

@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.

[JibinSebastian]

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

[JibinSebastian]

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

[v-hjannapu]

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.

[JibinSebastian]

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

[spencer_sa]

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

[spencer_sa]

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

[msprog · Accepted solution]

do you have a link to the announcement please?

[lbendlin]

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

[msprog]

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