Adding cloud tests

[mzitnik]

Summary

Adding cloud tests coverage

Checklist

Delete items not relevant to your PR:

• [ ] Unit and integration tests covering the common scenarios were added
• [ ] A human-readable description of the changes was provided to include in CHANGELOG
• [ ] For significant changes, documentation in https://github.com/ClickHouse/clickhouse-docs was updated with further explanations or tutorials

[CLAassistant]

All committers have signed the CLA.

[sonarqubecloud[bot]]

Quality Gate passed

Issues
0 New issues
0 Accepted issues

Measures
0 Security Hotspots
No data about Coverage
0.0% Duplication on New Code

See analysis details on SonarCloud

[chernser]

I think, this change would be good to adjust for running tests against any host not only cloud. Current version assumes that cloud using https protocol but test host may be another cases. At least correcting this thing would be a great addition. As for adding to CI - I think we create a separate workflow. Then we may merge it back. We may not require to run tests against cloud, I think.

[sonarqubecloud[bot]]

Quality Gate failed

Failed conditions
19.0% Coverage on New Code (required ≥ 80%)

See analysis details on SonarCloud