How does the Merge Table feature Work?

The Merge Tables option is provided in case of Database Sources. For MongoDB, it is referred as Merge Collections. If Pipeline mode as BinLog/OpLog/Logical Replication, and,

• If Merge Tables option is selected, then:
  • Event Type name = table name, and,

  • The name of the database is added to each record.

    

• If Merge Tables option is not selected, then:
  

  • Event Type name = database_name.table_name
    In the image below, the database name table_name_compression is prefixed to the table name.

    

Revision History