Skip to main content
Example of settings:

Setting fields:
The table or where fields cannot be used together with the query field. And either one of the table or query fields must be declared.
ssl_ca, ssl_cert and ssl_key name files that the server opens with its own privileges, so they are only accepted for a dictionary defined in a server configuration file, or through a named collection defined there. A CREATE DICTIONARY query that specifies the TLS credentials directly must pass their contents instead, in ssl_ca_pem, ssl_cert_pem and ssl_key_pem. Those values are masked in logs and in SHOW queries, the same way passwords are.
enable_local_infile lets the MySQL server ask ClickHouse for the contents of a file of its choosing, which the server reads with its own privileges, so it is only accepted for a dictionary defined in a server configuration file. A CREATE DICTIONARY query that enables it, at the source or at one of its <replica> entries, is rejected with BAD_ARGUMENTS.
There is no explicit parameter secure. When establishing an SSL-connection security is mandatory.
MySQL can be connected to on a local host via sockets. To do this, set host to localhost and socket. For any other host, socket is ignored and the connection goes over TCP. Without socket, the connection goes over TCP to port, also for localhost.
remote_url_allow_hosts checks only host and port: the path in socket is not checked.
Example of settings: