Switching data source for replication in Airbyte

Summary

Inquiring about switching data sources for replication in Airbyte without clearing data


Question

Hello all,

I am replicating data from MySQL to BigQuery via Airbyte.

I need to replicate data from a Replica MySQL DB to BigQuery to do an initial data load however I was hoping to then switch the to the Primary DB to replicate data via CDC and Bin Logs.
Is it possible to set up a connection with one data source then switch to use another data source without clearing the entire data and the new source being seen as a new connection?

Many thanks!!



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

["mysql-connector", "bigquery-connector", "data-replication", "cdc", "bin-logs"]