Clickhouse

Connect & Ingest data from / to a Clickhouse database

Sling CLI Setup
The following credentials keys are accepted:
host (required) -> The hostname / ip of the instance
user (required) -> he username to access the instance
database (required) -> The database name of the instance
schema (optional) -> The default schema to use
password (optional) -> The password to access the instance
port (optional) -> The port of the instance. Default is 9000.
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
Environment Variable
export CLICKHOUSE='clickhouse://myuser:[email protected]:9000/mydatabase'
Sling Cloud Setup
In Sling Cloud, click the Connections link on the left sidebar.
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.
If you are facing issues connecting, please reach out to us at [email protected].

BigQuery

MySQL

Last modified 1mo ago