Hi All, I'm trying to synchronize my OLTP Mysql database with Apache Pinot. I have a sharded MySQL setup where every tenant has its own database and tables (Example tenant1.users, tenant2.users). Each tenant has tables (like users) with the same schema. My ETL pipeline between MySQL and Pinot currently ingests change log data from MySQL binlog into Kafka and then Kafka connect is used to feed the change log data to Pinot.
How can I sync my sharded multitenant database without having to create schema configuration files for each table (Example tenant1.users, tenant2.users). Any help would be appreciated, Anshul Gupta