v.25.6Improvement

Make SQL UDF persistent in clickhouse-local

Official CH changelog text
Make SQL UDF persistent in clickhouse-local. The previously created function will be loaded at startup. This closes #80085. #80300 (Alexey Milovidov).
Make SQL User-Defined Functions (UDFs) persistent in clickhouse-local, so that functions created during a session are saved and automatically loaded on startup.

Why it matters

This feature addresses the limitation where SQL UDFs created in clickhouse-local were ephemeral and lost after the session ended. By persisting these functions, users can retain their custom UDFs across restarts, improving usability and workflow efficiency in clickhouse-local environments.

How to use it

Create SQL UDFs in clickhouse-local as usual. The functions will now be saved persistently and automatically loaded the next time clickhouse-local starts, with no additional configuration needed.

Related resources

PreviousNext