Remote and Cluster Table Functions in INSERT Queries

Why it matters

This feature allows users to perform insert operations directly on remote tables or tables across a cluster, simplifying data ingestion workflows in distributed environments and improving flexibility when writing data.

How to use it

Use the remote or cluster table functions in the INSERT INTO statement to write data to remote nodes or clusters. For example:

INSERT INTO remote('host:port', 'database', 'table') VALUES (...);

or

INSERT INTO cluster('cluster_name', 'database', 'table') VALUES (...);