v.21.3Improvement

Support for Virtual Host in RabbitMQ Engine

Support vhost for RabbitMQ engine #20576. #20596 (Kseniia Sumarokova).
Add support for specifying a virtual host (vhost) in the RabbitMQ engine for ClickHouse.

Why it matters

This feature allows users to connect the RabbitMQ engine in ClickHouse to a specific RabbitMQ virtual host (vhost). It solves the problem of limited connectivity options when working with RabbitMQ clusters configured with multiple virtual hosts, providing better isolation and routing control for message consumption.

How to use it

To use this feature, specify the desired RabbitMQ virtual host using the vhost parameter in the RabbitMQ table engine configuration. For example:

CREATE TABLE rabbitmq_table (
...
) ENGINE = RabbitMQ('host:port', 'exchange', 'queue', 'user', 'password', 'vhost' = '/my_vhost');