How does the Merge Table feature Work?

The Merge Tables option is provided for Database Sources. For MongoDB, it is referred to as Merge Collections. If Pipeline mode is BinLog, OpLog, or 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.