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'
If you are facing issues connecting, please reach out to us at [email protected].

BigQuery

DuckDB

Last modified 5mo ago