Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Did you hear? There's a new SQL AI Developer certification (DP-800). Start preparing now and be one of the first to get certified. Register now

Sukhwant_Kaur
Microsoft Employee
‎07-22-2025 11:15 AM

Connect to your SQL database in Fabric using Python Notebook

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:

  1. Create a new notebook in your workspace.
  2. Change the language to Python.

Connect_to_your_SQL_database_in_Fabric_using_Python_NotebookConnect_to_your_SQL_database_in_Fabric_using_Python_NotebookAI-generated content may be incorrect." />

3. Change the cell type to T-SQL.

Connect_to_your_SQL_database_in_Fabric_using_Python_NotebookConnect_to_your_SQL_database_in_Fabric_using_Python_Notebook

AI-generated content may be incorrect." />4. Add “%%tsql -artifact <databasename> -type SQLDatabase” before your T-SQL and hit run. 

 

Connect_to_your_SQL_database_in_Fabric_using_Python_NotebookConnect_to_your_SQL_database_in_Fabric_using_Python_NotebookAI-generated content may be incorrect." />

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. 

0