Sling Docs
Sling
Ask or search…
K
Links

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.
  • ssh_tunnel (optional) -> The URL of the SSH server you would like to use as a tunnel (example ssh://user:[email protected]:22)
  • ssh_private_key (optional) -> The private key to use to access a SSH server (raw string or path to file).
  • ssh_passphrase (optional) -> The passphrase to use to access a SSH server.
  • http_url (optional) -> The HTTP url to override the connection string (see https://github.com/ClickHouse/clickhouse-go?tab=readme-ov-file#http-support-experimental).
Here are examples 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 Env File YAML

See here to learn more about the sling env.yaml file.
connections:
CLICKHOUSE:
type: clickhouse
host: <host>
user: <user>
port: <port>
database: <database>
schema: <schema>
password: <password>
CLICKHOUSE_URL:
url: "clickhouse://myuser:[email protected]:9000/mydatabase"
If you are facing issues connecting, please reach out to us at [email protected] or open a Github Issue here.
Last modified 19d ago