v.24.8New Feature

Add Options to Replace External Engines with Null for Testing in RESTORE and Table Creation

Official CH changelog text
Add options restore_replace_external_engines_to_null and restore_replace_external_table_functions_to_null to replace external engines and table_engines to Null engine that can be useful for testing. It should work for RESTORE and explicit table creation. #66536 (Ilya Yatsishin).
Added options restore_replace_external_engines_to_null and restore_replace_external_table_functions_to_null to replace external table engines and table functions with the Null engine during RESTORE operations or explicit table creation.

Why it matters

These options allow users to substitute external engines and external table functions with the Null engine, which is useful for testing scenarios where external dependencies should be disabled or ignored to avoid execution errors or side effects.

How to use it

Users can enable these options by setting restore_replace_external_engines_to_null and/or restore_replace_external_table_functions_to_null to true in the server configuration or session settings. This will cause ClickHouse to replace any external engine or external table function with the Null engine during RESTORE commands or when creating tables explicitly.

Related resources

PreviousNext