Implement MongoDB Table Function for Write Operations in ClickHouse

Why it matters

This feature addresses the need to integrate ClickHouse with MongoDB by allowing users to write data directly from ClickHouse into MongoDB collections. It simplifies data pipelines and improves interoperability between these systems, providing seamless data transfer and storage synchronization.

How to use it

Use the mongodb table function in SQL queries to write data into MongoDB. For example, you can insert data by specifying the table function as the target in an INSERT INTO statement. Configure connection parameters such as host, port, database, collection, and authentication within the table function call.