v.24.1Improvement

Support FORMAT Clause in BACKUP and RESTORE Queries

Support the FORMAT clause in BACKUP and RESTORE queries. #59338 (Vitaly Baranov).
Support the FORMAT clause in BACKUP and RESTORE queries in ClickHouse.

Why it matters

This feature allows users to specify the backup format explicitly when creating or restoring backups, providing greater flexibility and control over backup storage and interoperability.

How to use it

Users can specify the backup format in their queries using the FORMAT clause within BACKUP and RESTORE commands. For example:

BACKUP TABLE my_table TO 'backup_path' FORMAT <format_name>;
RESTORE TABLE my_table FROM 'backup_path' FORMAT <format_name>;