v.24.9Experimental Feature

Replication of Subset of Columns Now Available in MaterializedPostgreSQL

Replication of subset of columns is now available through MaterializedPostgreSQL. Closes #33748. #69092 (Kruglov Kirill).
MaterializedPostgreSQL engine now supports replication of a subset of columns from the source PostgreSQL table.

Why it matters

This feature solves the problem of replicating large tables by allowing users to replicate only the necessary columns instead of the entire table, reducing storage and network overhead and improving performance.

How to use it

When creating a MaterializedPostgreSQL table, specify the desired subset of columns to replicate by defining the target columns explicitly in the table schema. This enables replication of only those specified columns from the source PostgreSQL table.