How would redshift compare to Yandexs' Clickhouse[1] for this kind of architecture?

[1] https://clickhouse.yandex/