Implementation
This handler was implemented using the standardclickhouse-sqlalchemy
library.
The required arguments to establish a connection are as follows:
host
is the hostname or IP address of the ClickHouse server.port
is the TCP/IP port of the ClickHouse server.user
is the username used to authenticate with the ClickHouse server.password
is the password to authenticate the user with the ClickHouse server.database
defaults todefault
. It is the database name to use when connecting with the ClickHouse server.protocol
defaults tonative
. It is an optional parameter. Its supported values arehttp
andhttps
.
If you installed MindsDB locally via pip, you need to install all handler dependencies manually. To do so, go to the handler’s folder (mindsdb/integrations/handlers/clickhouse_handler) and run this command:
pip install -r requirements.txt
.Usage
In order to make use of this handler and connect to the ClickHouse database in MindsDB, the following syntax can be used:If you want to switch to a different database instead of the one you have connected, you can include it in the query as: