v.23.8Improvement

Added Custom Storage Policy Support in RESTORE Queries

Official CH changelog text
Added the possibility to specify custom storage policy in the SETTINGS clause of RESTORE queries. #52970 (Victor Krasnov).
Added the ability to specify a custom storage policy in the SETTINGS clause of RESTORE queries.

Why it matters

This feature allows users to control where restored data is stored by specifying a storage policy during the RESTORE operation, enhancing flexibility and storage management.

How to use it

When executing a RESTORE query, include the desired storage policy using the SETTINGS clause, for example:

RESTORE TABLE your_table FROM backup
SETTINGS storage_policy = 'your_custom_policy'

Related resources

PreviousNext