Are Python External UDFs supported in Databricks SQL warehouse?

[AnubhavG]

I tried running a python UDF in the Databricks SQL warehouse but it did not run and gave the "Python UDF is not supported" error.

Can i get a clear picture if the Python External UDFs are supported or not?

[PriyaAnanthram]

Isnt this in private prview currently https://www.databricks.com/blog/2022/07/22/power-to-the-sql-people-introducing-python-udfs-in-databr...

[AnubhavG]

Isn't it released for the public preview yet?

In a webinar, I heard it is planned for Q3​.

[LandanG]

Hi @Anubhav Gupta ​, 

UDF's are currently still in private preview with the public preview being pushed back a bit. You can ask your Databricks rep/SA to see if you're eligible (due to early stage technical requirements) for the preview

[AnubhavG]

Thanks for the reply @Landan George​ 

Also Do we have the capability of calling an API using Python UDF in private preview?

If not then ,Is there any way we can call an API in Databricks SQL by any chance?

[LandanG]

@Anubhav Gupta​ As of right now there is no network connectivity for SQL UDFs (so no API calls) but that may come later down the line.

I'm not sure if there's a way to use APIs in DB SQL but depending on your use case there might be a workaround using different features.

[AnubhavG]

@Landan George​  The use case is I want to tokenize/encrypt the SQL data using the API call.

Is there a way I can achieve this.

[youssefmrini · Accepted solution]

It's a private preview and It will be supported only in PRO SQL Warehouse and the Serverless SQL Warehouse

[Ajay-Pandey]

Thanks