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

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

[spencer_sa]

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

[msprog · Accepted solution]

do you have a link to the announcement please?

[spencer_sa]

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