Can DM synchronize only specific fields of a table instead of all fields?

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: DM 是否可以只同步一个表的指定字段,而不是全部字段。

| username: 超7成网友

As the topic suggests,
if the upstream table has 10 fields but the downstream only uses 2 fields, is it possible to synchronize only those 2 fields?

| username: GreenGuan | Original post link

As far as I know, DM does not have a column pruning feature. To achieve this requirement, you can try using the dumpling/lighting tools, combined with the --snapshot parameter, to create a tool with ETL functionality.

| username: notebook385 | Original post link

DM does not yet have the function to filter fields, only to filter tables.

| username: Hacker007 | Original post link

No, dear, the minimum dimension for DM synchronization is the table.

| username: Hacker007 | Original post link

You can create views on the TiDB side.

| username: system | Original post link

This topic will be automatically closed 60 days after the last reply. No new replies are allowed.