Table Groups

Table Group is a logical group of tables in a Fivetran HVR channel. This option allows to efficiently define actions in a channel. This is especially useful for heterogeneous channels with lots of tables belonging to different schemas on source and target locations. Grouping tables in one table group allows you to define a single action for a group of tables, rather than defining multiple identical actions for each table separately.

For example, suppose there is an Oracle to Snowflake channel containing 1000 tables, 800 of which belong to schema ora_a and should be replicated to target schema snowf_a, the other 200 tables belong to schema ora_b and should be replicated to target schema snowf_b. The 800 tables can be assigned to table group GROUP_A, the 200 tables can be assigned to table group GROUP_B. This allows to define only four TableProperties actions with parameter Schema for this channel:

Channel	Location	Table	Action	Parameter(s)
mychn	SOURCE	GROUP_A	TableProperties	Schema=ora_a
mychn	SOURCE	GROUP_B	TableProperties	Schema=ora_b
mychn	TARGET	GROUP_A	TableProperties	Schema=snowf_a
mychn	TARGET	GROUP_B	TableProperties	Schema=snowf_b

When you add tables to a channel in the User Interface using the Table Selection dialog, the tables are assigned to group GENERAL by default. You can change the group name by entering a custom name in the Group name field. If you select Auto-assign schema as group name, the table group name for each table will be derived from a schema name to which a table belongs and cannot be changed manually. Group names are always in uppercase.

Each table is a member of one table group.