Forum Discussion
Solved
Load custom SQL function from Azure Synapse into Microsoft Fabric Lakehouse
Hi all, Let me start with this - I am 99.99% new to Fabric... What I have done so far is load some tables from Azure Synapse into Fabric in a Lakehouse via a Dataflow Gen2. What I also want ...
Hi mtomova
- After creating stored procedure in Azure Synapse that includes your custom SQL function, create a pipeline Script activity to run the stored procedure in Fabric environment.
- Then in the pipeline use copy asiatnat activity to load preprocessed table data into Lakehouse. Now, execute the two pipeline activities to load the data in to your Lakehouse.
Please go through this official documentaion Preprocess data with a stored procedure before loading into Lakehouse - Microsoft Fabric | Microsoft Learn it might helps you to solve your problem.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Hi, thank you for the link you have shared.
Unfortunatelly, that doesn't seem to be working for me, because my SQL function is not creating a table.
I have created the function in Fabric itself and I can use it when I pass parameters, but when I try to use it in another query (my function counts working days between two dates) the query just runs forever with no result.
Thanks,
Maria