Tests schema are not being cleaned up

[BentsiLeviav]

Describe the bug

For some reason, the tests' schemas are not being deleted when running with ClickHouse cloud..

Expected behavior

The schema is supposed to be cleaned properly.

Code examples, such as models or profile settings

A screenshot showing the schemas:

Suggested Solution

We need to go through the cleanup implementation to ensure it is airtight.