https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-Creating-stored-procs-using-Notebooks/m-p/4088030#M3483 <P>HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/787733">@Soobramoney</a>,</P> <P>Perhaps you can use the pyodbc to connect to the data source and execute the create SP command:</P> <LI-CODE lang="python">import pyodbc # copy and paste the SQL endpoint from any of the Lakehouses or Warehouses in your Fabric Workspace server = "your endpoint" # copy and paste the name of the Lakehouse or Warehouse you want to connect to database="YourDatabase" # use Service principal to connect clientId = "" clientSecret = mssparkutils.credentials.getSecret("https://YourKeyVault.vault.azure.net/","your-client-secret-secret-name") constr = f"driver=ODBC Driver 18 for SQL Server;server={server};database={database};UID={clientId};PWD={clientSecret};Authentication=ActiveDirectoryServicePrincipal;Encrypt=yes;Timeout=60;" con = pyodbc.connect(constr) cursor = con.cursor() create_SP_Command="" result=cursor.execute(create_SP_Command) print(result) cursor.close() con.close()</LI-CODE> <P><A href="https://stackoverflow.com/questions/78285603/load-data-to-ms-fabric-warehouse-from-notebook" target="_blank">Load data to MS Fabric Warehouse from notebook - Stack Overflow</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 08 Aug 2024 02:00:18 GMT Anonymous 2024-08-08T02:00:18Z https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-Creating-stored-procs-using-Notebooks/m-p/4086878#M3470 <P>Hi guys,</P><P>&nbsp;</P><P>Is it possible to create a stored proc on Fabric lakehouse from a notebook?</P> Wed, 07 Aug 2024 14:02:21 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-Creating-stored-procs-using-Notebooks/m-p/4086878#M3470 Soobramoney 2024-08-07T14:02:21Z https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-Creating-stored-procs-using-Notebooks/m-p/4088030#M3483 <P>HI&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/787733">@Soobramoney</a>,</P> <P>Perhaps you can use the pyodbc to connect to the data source and execute the create SP command:</P> <LI-CODE lang="python">import pyodbc # copy and paste the SQL endpoint from any of the Lakehouses or Warehouses in your Fabric Workspace server = "your endpoint" # copy and paste the name of the Lakehouse or Warehouse you want to connect to database="YourDatabase" # use Service principal to connect clientId = "" clientSecret = mssparkutils.credentials.getSecret("https://YourKeyVault.vault.azure.net/","your-client-secret-secret-name") constr = f"driver=ODBC Driver 18 for SQL Server;server={server};database={database};UID={clientId};PWD={clientSecret};Authentication=ActiveDirectoryServicePrincipal;Encrypt=yes;Timeout=60;" con = pyodbc.connect(constr) cursor = con.cursor() create_SP_Command="" result=cursor.execute(create_SP_Command) print(result) cursor.close() con.close()</LI-CODE> <P><A href="https://stackoverflow.com/questions/78285603/load-data-to-ms-fabric-warehouse-from-notebook" target="_blank">Load data to MS Fabric Warehouse from notebook - Stack Overflow</A></P> <P>Regards,</P> <P>Xiaoxin Sheng</P> Thu, 08 Aug 2024 02:00:18 GMT https://community.fabric.microsoft.com/t5/Data-Engineering/Lakehouse-Creating-stored-procs-using-Notebooks/m-p/4088030#M3483 Anonymous 2024-08-08T02:00:18Z