simple clickhouse https connector

clickhouse.cs

//dont forget to sudo update-ca-certificates after certificate download from yandex cloud

public class ClickHouseConnection
    {
        public string Host { get; }
        public string User { get; }
        public string Password { get; }
        public string Db { get; }
    
        public ClickHouseConnection(string host, string user, string password, string db)
        {
            Host = host;
            User = user;
            Password = password;
            Db = db;
        }
        public static async Task<string> QueryClickhouse(ClickHouseConnection connections, string query)
        {
            var url = $"https://{connections.Host}:8443/?database={connections.Db}&query={query}";
            var client = new HttpClient();
            client.DefaultRequestHeaders.Add("X-ClickHouse-User", connections.User);
            client.DefaultRequestHeaders.Add("X-ClickHouse-Key", connections.Password);
            var res = await client.GetStringAsync(url);
            return res;
        }
    }