ClickHouse

ClickHouse

Warehouses

Overview

Send your ecommerce data to ClickHouse for blazing-fast columnar analytics, real-time aggregations, and efficient storage of large datasets.

Setup

  1. 1

    Create a ClickHouse Cloud account or use an existing ClickHouse instance.

  2. 2

    Note your host, port, database, and credentials.

  3. 3

    Go to Dashboard > Outputs, click Connect on ClickHouse, and enter your connection details.

  4. 4

    Data syncs automatically to your ClickHouse database.

Tips

  • ClickHouse Cloud offers a free tier for getting started.
  • Make sure your IP access list allows connections from our servers.

Fields Required

Host

your-clickhouse.cloud

Port

8443

Database

ecommerce

Username

default

Password

your_password

Secret

Setup Guide

  1. 1

    Go to ClickHouse Cloud and sign in or create a free account.

    https://clickhouse.cloud/
  2. 2

    Click "New Service" to create a ClickHouse service (or use an existing one).

  3. 3

    Open the service details — your Host is shown in the connection string.

  4. 4

    Use port 8443 for HTTPS connections.

  5. 5

    The default database is "default", or create a new one in the SQL console.

  6. 6

    Username is "default" and the password was shown when the service was created.

Tips

  • If you lost your password, go to Settings on your service and reset credentials.
  • Make sure your ClickHouse IP access list allows connections from our servers.