fix: clickhouse zookeeper table metadata

[cisse21]

Description

The proposed change involves introducing a UUID to the storage path in Zookeeper in ClickHouse's cluster mode. This modification aims to address the issue where dropping and recreating a table takes 7-8 minutes for the metadata to be cleared. By adding a UUID to the storage path, the implementation ensures that such operations can be executed instantly, allowing data to be written to a different path in ZooKeeper. This enhancement improves the efficiency of table management in ClickHouse clusters.

Linear Ticket

Fixes PIPE-482

Security

• The code changed/added as part of this pull request won't create any security issues with how the software is being used.

[codecov]

Codecov Report

All modified and coverable lines are covered by tests ✅

Comparison is base (6c28e25) 72.36% compared to head (354ebce) 72.56%.

Additional details and impacted files

@@            Coverage Diff             @@
##           master    #4121      +/-   ##
==========================================
+ Coverage   72.36%   72.56%   +0.20%     
==========================================
  Files         382      382              
  Lines       55420    55420              
==========================================
+ Hits        40105    40217     +112     
+ Misses      12983    12884      -99     
+ Partials     2332     2319      -13     

☔ View full report in Codecov by Sentry.
📢 Have feedback on the report? Share it here.

[redsquare]

yay