# UDF/UDAF on confluent cloud

**URL:** https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569
**Category:** Confluent Cloud
**Created:** [6 December 2021 06:12 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569 "2021-12-06T06:12:46Z")
**Posts on this page:** 8
**Page:** 1

<div class="post-metadata">

### Author: ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)
#### Post date: [6 December 2021 06:12 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/1 "2021-12-06T06:12:46Z")

</div>

Is it possible to configure UDF’s/UDAF’s on conlfluent cloud for KSQL.

If yes, any documentation on it?

Thanks.

---

<div class="post-metadata">

### Author: ![mmuehlbeyer](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.confluent.io/mmuehlbeyer/32/1088_2.png) [@mmuehlbeyer](https://forum.confluent.io/u/mmuehlbeyer)
#### Post date: [6 December 2021 08:07 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/2 "2021-12-06T08:07:57Z")

</div>

Hi @shubhamshirur

this tutorial might help:

> **[How to build a User-Defined Function (UDF) to transform events using ksqlDB](https://developer.confluent.io/tutorials/udf/ksql.html)**
>
> In this tutorial, learn how to build a User-Defined Function (UDF) to transform events using ksqlDB, with step-by-step instructions and examples.

as well as this blog post

> **[ksqlDB UDFs and UDAFs Made Easy | Confluent](https://www.confluent.io/blog/kafka-ksql-udf-udaf-with-maven-made-easy/)**
>
> This tutorial helps you quickly bootstrap your ksqlDB UDF and UDAF projects by building your own custom ksqlDB functions using the Maven archetype available in Confluent Platform 5.3.0.

Best,  
michael

---

<div class="post-metadata">

### Author: ![David](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@David](https://forum.confluent.io/u/David)
#### Post date: [3 October 2022 17:26 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/3 "2022-10-03T17:26:06Z")

</div>

From my reading of the tutorials, it appears that you can run UDFs/UDAFs on your own deployment of ksqlDB, and can use your own deployment of ksqlDB to process topics in a Confluent Cloud Kafka cluster. What I don’t see is the ability to run UDFs/UDAFs on the hosted ksqlDB cluster.

Is it possible to run UDFs/UDAFs on a ksqlDB cluster hosted in Confluent Cloud? If not, is this in the roadmap for Confluent Cloud?

---

<div class="post-metadata">

### Author: ![David](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@David](https://forum.confluent.io/u/David)
#### Post date: [6 October 2022 14:14 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/4 "2022-10-06T14:14:21Z")

</div>

@mmuehlbeyer Do you know?

---

<div class="post-metadata">

### Author: ![shubhamshirur](https://avatars.discourse-cdn.com/v4/letter/s/4bbf92/32.png) [@shubhamshirur](https://forum.confluent.io/u/shubhamshirur)
#### Post date: [7 October 2022 05:19 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/5 "2022-10-07T05:19:54Z")

</div>

Hello Team,

I am trying to create UDFs for confluent platform KSQLDB. I followed [ksqldb.io](http://ksqldb.io) documentation for UDFs and followed steps accordingly, create Java class, assigned annotations, created executable jar of it and pasted in directory which is refernced in ksql-server.properties with name ‘ksql.extension.dir’.

Once ksql-server is up, I can describe function and can see its descriptions except variations field in description. Also, when I tried to run that function in query, it says it can not accept string parameter but in java code @UdfParameters is String as shown below.

> `DESCRIBE function convert;`
> 
> ```auto
> {
> "@type": "describe_function",
> "statementText": "DESCRIBE function convert;",
> "name": "CONVERT",
> "description": "converts json string to json data format",
> "author": "shubham shirur",
> "version": "0.0.1",
> "path": "/data/ext/UDFs-1.0-SNAPSHOT-jar-with-dependencies.jar",
> "functions": [
> 
> ],
> "type": "SCALAR",
> "warnings": [
> 
> ]
> }
> 
> ```

> Function ‘convert’ does not accept parameters (STRING). Valid alternatives are: For detailed information on a function run: DESCRIBE FUNCTION ; Statement: select convert(event) from TEST\_EXTRACT EMIT CHANGES;

---

<div class="post-metadata">

### Author: ![ploy\_dev](https://avatars.discourse-cdn.com/v4/letter/p/85f322/32.png) [@ploy\_dev](https://forum.confluent.io/u/ploy_dev)
#### Post date: [25 September 2023 11:17 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/6 "2023-09-25T11:17:26Z")

</div>

Hi David, I’m new for ksqldb and also want to deploy UDF on ksqldb in confluent cloud. Do you know if it is possible to do that?

Thank you so much,

---

<div class="post-metadata">

### Author: ![David](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@David](https://forum.confluent.io/u/David)
#### Post date: [26 September 2023 06:00 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/7 "2023-09-26T06:00:59Z")

</div>

Soon after I asked the question here, I asked Confluent support, and the answer was that UDF was not supported in Confluent Cloud. We then dropped the idea of using ksqldb. I don’t know the current situation.

---

<div class="post-metadata">

### Author: ![ploy\_dev](https://avatars.discourse-cdn.com/v4/letter/p/85f322/32.png) [@ploy\_dev](https://forum.confluent.io/u/ploy_dev)
#### Post date: [26 September 2023 07:10 UTC](https://forum.confluent.io/t/udf-udaf-on-confluent-cloud/3569/8 "2023-09-26T07:10:07Z")

</div>

Got it, Thank you so much
