MongoDB dictionary source

Configure MongoDB as a dictionary source in ClickHouse.

Example of settings:

DDL

SOURCE(MONGODB(
    host 'localhost'
    port 27017
    user ''
    password ''
    db 'test'
    collection 'dictionary_source'
    options 'ssl=true'
))

Or using a URI:

SOURCE(MONGODB(
    uri 'mongodb://localhost:27017/clickhouse'
    collection 'dictionary_source'
))

Configuration file

<source>
    <mongodb>
        <host>localhost</host>
        <port>27017</port>
        <user></user>
        <password></password>
        <db>test</db>
        <collection>dictionary_source</collection>
        <options>ssl=true</options>
    </mongodb>
</source>

Or using a URI:

<source>
    <mongodb>
        <uri>mongodb://localhost:27017/test?ssl=true</uri>
        <collection>dictionary_source</collection>
    </mongodb>
</source>

Setting fields:

Setting	Description
host	The MongoDB host.
port	The port on the MongoDB server.
user	Name of the MongoDB user.
password	Password of the MongoDB user.
db	Name of the database.
collection	Name of the collection.
options	MongoDB connection string options. Optional.
uri	URI for establishing the connection (alternative to individual host/port/db fields).

More information about the engine