facing issue here when in airbyte droping pre-exis...
# replication-troubleshooting
a
facing issue here when in airbyte droping pre-existing table on destination (clickhouse). stream type:- [Scan Changes with User Defined Cursor] source connn:- (mysql ) destinatin conn:- clickhouse (multi shard, multi replica) looking for setting / option with help of which, I can make sure when initial sync starts for table, with pre-defind table is created using specific table engine ( with reqiuired airbyte system columns)
m
Hey Alpesh, not sure I completely understand your question. As far as data replication in general: when you create a connection with Airbyte, the destination database tables will have Airbyte metadata columns appended. We don't drop existing tables.