topic While creating a UDF in databricks SQL, how can I declare a local variable? Something like this? CREATE OR REPLACE FUNCTION len() set myString = 'my value'; RETURNS INT RETURN length(myString); in missing-QuestionPost

While creating a UDF in databricks SQL, how can I declare a local variable? Something like this? CREATE OR REPLACE FUNCTION len() set myString = 'my value'; RETURNS INT RETURN length(myString);

RV — Fri, 09 Jun 2023 13:26:17 GMT

Anonymous — Fri, 16 Jun 2023 06:02:49 GMT

Hi @Ravi V

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.