v.23.5Improvement

Enable MongoDB Connection Options for Dictionary Source

Official CH changelog text
Enable connection options for the MongoDB dictionary. Example: 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> ### Documentation entry for user-facing changes. #49225 (MikhailBurdukov).
Support for specifying connection options in the MongoDB dictionary source configuration in ClickHouse.

Why it matters

This feature allows users to provide additional connection parameters (such as SSL and other MongoDB client options) when configuring MongoDB dictionaries. It enhances flexibility and security by enabling customized connection settings to MongoDB instances.

How to use it

In the MongoDB dictionary XML configuration, add the <options> tag inside the <mongodb> section to specify connection options. For example:

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

Related resources

PreviousNext