topic Re: Turn on UDFs in Databricks SQL feature in Data Governance

Turn on UDFs in Databricks SQL feature

DAUR — Fri, 02 Jun 2023 18:03:23 GMT

Hello,

Im using Unity Catalog managed tables and Unity Catalog DLTs. I urgently need to use a UDF in DBSQL because pySpark UDFs dont work in UC. I found this way to create a SQL function and use python language inside:

CREATE FUNCTION redact(a STRING)
RETURNS STRING
LANGUAGE PYTHON
AS $$ 
  return "Hello World"
$$;

I got the error:

Error in SQL statement: AnalysisException: [FEATURE_UNAVAILABLE] Python UDF is not supported in your environment. To use this feature, please contact Databricks Support.

How can I turn on this feature?

Re: Turn on UDFs in Databricks SQL feature

fkseki — Fri, 02 Jun 2023 19:54:03 GMT

If this functionality is available in a private preview, first thing to do is to get in touch with your Databricks representative to ask for your workspace to be included in it

Re: Turn on UDFs in Databricks SQL feature

youssefmrini — Mon, 05 Jun 2023 09:14:03 GMT

It will be available soon in public preview. You will need to have a Pro SQL Warehouse or a Serverless SQL Warehouse to use Python UDF in Databricks SQL.