v.23.7New Feature

Add disable_url_encoding setting to URL engine

Official CH changelog text
Add new setting disable_url_encoding that allows to disable decoding/encoding path in uri in URL engine. #52337 (Kruglov Pavel).
Added a new setting disable_url_encoding to the URL table engine that allows disabling the decoding and encoding of the path in the URI.

Why it matters

This feature addresses the need to control how paths in URIs are handled by the URL table engine. By disabling URL encoding and decoding of the path, users can work with raw URI paths as-is, preventing unintended transformations and ensuring compatibility with endpoints that require exact path formatting.

How to use it

To use this feature, set the disable_url_encoding setting to 1 when querying the URL engine or in the server configuration. This disables automatic URL path encoding and decoding. Example:

SET disable_url_encoding = 1;
SELECT * FROM url('http://example.com/data/path', 'JSONEachRow');

Related resources

PreviousNext