How to connect a Notebook to an existing Fabric connection without using Pipeline.

[JānisB]

There is an existing connection (Manage connections and gateways). For example connection ID: aaabbb .

Is it possible to connect a Notebook (T-SQL and Python and PySpark(Python)) to an existing Fabric connection without using Pipeline?

[v-achippa · Accepted solution]

Hi @JānisB,

Thank you for reaching out to Microsoft Fabric Community.

As of now, fabric does not support directly connecting a Notebook (T-SQL, Python, or PySpark) to an existing fabric connection from "Manage connections and gateways" without using a pipeline.

• The "Manage connections and gateways" feature in fabric is mainly used for Data Pipelines, Dataflows, and Linked Services to connect to external data sources.
• Fabric Notebooks (T-SQL, Python, PySpark) do not natively support direct connections to these pre-configured connections.
• Notebooks typically connect directly to Lakehouse, Data Warehouse or KQL Database directly rather than through "Manage connections and gateways".

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks and regards,

Anjan Kumar Chippa

[spartan27244]

So how would you connect to say an Azure SQL database in PySpark?