Clickhouse
Connect & Ingest data from / to a Clickhouse database
The following credentials keys are accepted:
host
(required) -> The hostname / ip of the instanceuser
(required) -> he username to access the instancedatabase
(required) -> The database name of the instanceschema
(optional) -> The default schema to usepassword
(optional) -> The password to access the instanceport
(optional) -> The port of the instance. Default is9000
.
Here is an example of setting a connection named
CLICKHOUSE
. We must provide the type=clickhouse
property:$ sling conns set CLICKHOUSE type=clickhouse host=<host> user=<user> database=<database> password=<password> port=<port>
# OR use url
$ sling conns set CLICKHOUSE url=clickhouse://myuser:[email protected]:9000/mydatabase
export CLICKHOUSE='clickhouse://myuser:[email protected]:9000/mydatabase'
- On top, click New Connection.
- Search for "Clickhouse". Click on it.
- Input the needed information.
- Click Test to verify connectivity.
- Click Save to save the connection.
Last modified 1mo ago