Setting default engine to ReplicatedMergeTree in Airbyte for Clickhouse sync

[slack-user-airbyte]

Summary

How to configure Airbyte to use ReplicatedMergeTree engine instead of MergeTree for Clickhouse sync to utilize parallel replicas.

Question

Hi. I’m using Airbyte to sync data from sources to Clickhouse (2 replicas). How to set default engine when Airbyte creates tables to ReplicatedMergeTree engine instead of MergeTree ? MergeTree can’t utilize parallel replicas.

---

This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.

Join the conversation on Slack

_{["airbyte", "clickhouse", "replicatedmergetree", "merge-tree", "parallel-replicas"]}