Load data to Fabric sql database using notebook

[Sharika_]

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?

[dlevy]

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.

[Anonymous]

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