# ClickHouse

**Integration type**: `Read` `Write` `SQL`

Integration with ClickHouse allows you to read and write data from and to ClickHouse instances in a streaming mode.

**Data for the connection:**

<figure><img src="https://3180830455-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FD0FT8l3QzMrw546vOdHU%2Fuploads%2Fz2aBLapVQ4EzkQkWE8BI%2FScreenshot%202024-04-23%20at%2016.30.21.png?alt=media&#x26;token=2797eede-d352-45fb-ba0e-40ffad6c18bd" alt=""><figcaption></figcaption></figure>

ClickHouse supports both direct and SSH connection types. But for security reasons, we recommend always using SSH tunnels with restricted access from Ylem's IP.