Skip to content

Clickhouse

Write Honeypot events directly to Clickhouse by following these steps:

  1. From the connectors page, select , and then click .

  2. An example configuration will appear in the tab. Update the connection information with the appropriate values for your Clickhouse instance.

    json
    {
        // Clickhouse server URL with port
        "url": "https://xxxxx.clickhouse.cloud:443",
    
        // Username for authentication
        "username": "default",
    
        // Password for authentication
        "password": "****",
    
        // Table name to store events in
        "table": "honeypot_events"
    }
  3. From the tab, use the filter builder to control which events should be written to the connector.

Filter builder

  1. Click the tab, and run the CREATE TABLE statement to prepare the downstream table.

Clickhouse connector

  1. Click to save the connector.

  2. From the tab, you can monitor the write volume.

Connector metrics