MongoDB dictionary source - Clickhouse

import Tabs from '@theme/Tabs'; import TabItem from '@theme/TabItem';

Example of settings:

sql

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

Or using a URI:

sql

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

</TabItem> <TabItem value="xml" label="Configuration file">

xml

<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:

xml

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

</TabItem> </Tabs>

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