topic Load data to Fabric sql database using notebook in SQL database

Load data to Fabric sql database using notebook

Sharika_ — Wed, 19 Mar 2025 21:13:50 GMT

I want to load data to the Fabric SQL database using Fabric Notebook (pyspark) . I also can not use pipelines or dataflow. Is there any way to do that?

Re: Load data to Fabric sql database using notebook

Anonymous — Thu, 20 Mar 2025 01:00:59 GMT

Hi Sharika_

You can try using JDBC Connector with AAD Token:

Connectivity to data warehousing - Microsoft Fabric | Microsoft Learn
Microsoft Entra authentication - Azure SQL Database & Azure SQL Managed Instance & Azure Synapse Analytics | Microsoft Learn
JDBC To Other Databases - Spark 3.5.5 Documentation

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Load data to Fabric sql database using notebook

dlevy — Wed, 26 Mar 2025 15:26:53 GMT

Hi Sharika_ - Sorry to hear things aren't working right! Notebooks are something we are working on (the instructions already shared are a solid workaround) but pipelines and data flows should just work. The key part there is to make sure that you are connecting to the SQL database endpoint and not the SQL Analytics endpoint because the analytics side is read only. If you are still having trouble then pleanse open a support case so we can dig into what is going wrong.