Stored procedure exec in lakehouse

[RonaldBalza-943]

Hey everyone, quick question. I've got a stored procedure in my Fabric Lakehouse and I'm trying to execute it directly from there (just aiming to create a simple table, for example). However, when using the SQL Analytics endpoint and T-SQL in a notebook, I'm unable to get it to run. Any suggestions or advice? Thanks!

[suparnababu8]

Hi @RonaldBalza-943 

'just aiming to create a simple table'  mean>>> are you trying to create a new table in Lakehouse by using T-SQL? if yes, it's not possible in lakehouse. 

Can you please elaborate your question?

thanks!!

[RonaldBalza-943]

Yes, the stored procedure is intended to create a table. If it’s not possible to do this within the Lakehouse environment, could you please point me to the relevant documentation? Also, is there any alternative way to execute the stored procedure in Lakehouse? Thanks very much!

[V-yubandi-msft]

Hi @RonaldBalza-943 ,

Just add to @suparnababu8 , response for further clarification. Unfortunately, you can't create tables directly in the Fabric Lakehouse using stored procedures due to limitations in the supported T SQL Surface Area for the Lakehouse environment.

FYI:

Please refer to the document below for further clarification.

T-SQL Surface Area in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

1. To understand which T-SQL features are supported, check out the official documentation on the T-SQL Surface Area in Fabric Data Warehouse. It explains the functionalities and restrictions in detail.
2. Although direct table creation isn't possible, you can preprocess your data using a stored procedure before loading it into the Lakehouse Preprocess data with a stored procedure before loading into Lakehouse - Microsoft Fabric | Microsoft...

Thank you for your inputs @suparnababu8 .

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

[suparnababu8 · Accepted solution]

Hi @RonaldBalza-943 

Creating tables by using stored procedures is directly not possible in Fabric lakehouse. Can you please refer this documentation T-SQL Surface Area in Fabric Data Warehouse - Microsoft Fabric | Microsoft Learn

There is another way to create tables by using stored procedure. Please refer this thread Preprocess data with a stored procedure before loading into Lakehouse - Microsoft Fabric | Microsoft...

Thank you!!