Read/Write to SQL database in Fabric using Python Notebook
You created your SQL database in Fabric because you wanted to take full advantage of all the existing workloads without worrying about integration pain points. Python notebook integration with SQL was highly requested. We are thrilled to share you can seamlessly use a python notebook to connect to SQL database in Fabric with the help of T-SQL Magic command. This command allows users to harness the full power of Transact-SQL (T-SQL) in ways that were previously unimaginable, blending advanced scripting with intuitive workflows, automation, and seamless integration across the Fabric data platform.
Key benefits of using Notebook for SQL database
- Notebook-Style Querying: Interact with your SQL Database using enriched notebooks—combine queries, visualizations, and explanatory text in a single, shareable document.
- Built-in Visualization: Instantly visualize query results using rich, interactive charts and graphs—no need to export data to external tools.
- Automation and Scheduling: Schedule routine jobs, automate data refreshes, and trigger notifications directly from T-SQL scripts, putting operational control at your fingertips.
- Collaboration and Sharing: Share live T-SQL notebooks with peers, embed results in reports, and collaborate in real-time within the Fabric workspace.
- Secure by Design: Leverage Fabric’s enterprise-grade security.
Getting Started:
- Create a new notebook in your workspace.
- Change the language to Python.
Connect_to_your_SQL_database_in_Fabric_using_Python_Notebook
3. Change the cell type to T-SQL.
Connect_to_your_SQL_database_in_Fabric_using_Python_Notebook
4. Add “%%tsql -artifact <databasename> -type SQLDatabase” before your T-SQL and hit run.
Connect_to_your_SQL_database_in_Fabric_using_Python_Notebook
This is our first step to connecting python notebook with SQL database in Fabric. There’s more on the way stay tuned for more.
Please try this new functionality and share your feedback on Fabric Ideas and join the conversation on the Fabric Community.
To Learn more about this preview feature check out Run T-SQL code in Fabric Python notebooks - Microsoft Fabric | Microsoft Learn
To get into the technical details, head over to the Fabric documentation.
Microsoft Employee