Best ways to write a Pandas Dataframe on Fabric SQL Database

Hi dpombal, 

Connect to Your SQL Database - Microsoft Fabric | Microsoft Learn

Fabric Python Notebooks (preview) offer the ability to run T-SQL code with the T-SQL magic command. In the following steps, connect to a SQL database in Fabric using the %%tsql magic command:

1. Create a notebook in your workspace with the language set to Python.

2. In a cell, use the %%tsql magic command. The cell type automatically changes to T-SQL.

   In the following sample, replace <databasename> with the name of your SQL database in Fabric. The -type parameter should be SQLDatabase.

   PythonCopy

    

   %%tsql -artifact <databasename> -type SQLDatabase

   Then include your T-SQL command. For example, to run a query from a database named Contoso:

   PythonCopy

    

   %%tsql -artifact Contoso -type SQLDatabase
   SELECT * FROM SalesLT.Customer;

3. You can also bind the results to a dataframe with the -bind argument:

   PythonCopy

    

   %%tsql -artifact Contoso -type SQLDatabase -bind df2

For more possibilities to query your data with T-SQL inside Python Notebooks, see Run T-SQL code in Fabric Python notebooks. To see the full syntax, use the %tsql? command. This command displays the help information for the T-SQL magic command, including the available parameters and their descriptions.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution

Hi dpombal 

You can convert pandas dataframe to lakehouse/warehouse using python programming language. 

SQL Database = Lakehouse = Fabric Warehouse = Power BI Direct Lake Semantic Model. They all are same. Simple and Sweet.