RE: udf

[smpa01]

Can you please confirm whether udfs are all session scoped and persistent udfs are not possible to create (in lakehouse) as one can in databricks catalog?

[v-prasare]

I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas.

Feedback submitted here is often reviewed by the product teams and can lead to meaningful improvement. you query about UDFs is valid, please submit feedback and upvote this idea.

[v-prasare]

Hi @smpa01,

We are here to check whether solution provided answers your question. If you still have any additional questions please do let us know

Thanks,

Prashanth Are

MS Fabric community support

[smpa01]

What is the practical use case of udf in fabric then?

[v-prasare]

Hi @smpa01,

• UDFs in the Lakehouse (via Notebooks or SQL Analytics Endpoints) are session-scoped only. Persistent UDFs are not supported in Lakehouse currently.

• Each time you start a new session, you'd need to re-define your UDFs manually if you need them again.

Please refer to below blog and let u know if this helps?

https://blog.fabric.microsoft.com/en-US/blog/announcing-the-general-availability-of-session-scoped-d...

Thanks,

Prashanth Are