Can we write data to warehouse from fabric notebook?

[nnk9]

Hi,

I can find we have notebooks and can read and write data from lakehouse. I am looking for options to write data to warehouse from notebook. Can any one help me here?

[AleksiPartanen]

Now this can be done with Spark connector for Microsoft Fabric Data Warehouse.

Video on YouTube how to use this connector for reading and writing data:
https://youtu.be/3vBbALjdwyM

Official documentation about it:
https://learn.microsoft.com/en-us/fabric/data-engineering/spark-data-warehouse-connector?tabs=pyspar...

[Anonymous · Accepted solution]

Hi @nnk9 ,

Thanks for using Fabric Community.
At present we don't have any direct way to modify Warehouse from Notebooks. Only TSQL can modify warehouse tables. 

Docs to refer - Updating Fabric warehouse tables through a notebook - Stack Overflow

We also have a good news for you -

After the release -

Click Here 

Docs to refer -
What's new and planned for Synapse Data Engineering in Microsoft Fabric - Microsoft Fabric | Microso...

Hope this is helpful. Please let me know incase of further queries.

[NeedAUserName]

Is this still planned? I can't find it on the roadmap.

[nnk9]

Thank you @Anonymous . It is helpful.