v.21.7Improvement

SSD_CACHE Creation Limitations in user_files Directory

If SSD_CACHE is created with DDL query, it can be created only inside user_files directory. #24466 (Maksim Kita).
The SSD_CACHE can now be created only inside the user_files directory using a DDL query.

Why it matters

This feature ensures that when creating an SSD_CACHE via DDL, it is restricted to the user_files directory, enhancing security and consistency of cache file locations.

How to use it

To use this feature, create the SSD_CACHE with a DDL query specifying the cache inside the user_files directory, for example:

CREATE SSD_CACHE 'user_files/<cache_name>' SETTINGS ...;