How does the Merge Table feature Work?

Last updated on Jun 12, 2023

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.

      Merge Tables option is enabled

  • 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.

      Merge Tables option is disabled

Revision History

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Nov-07-2022 NA Created as a new document.

Tell us what went wrong