ClickHouse on Ubuntu 24.04 LTS

What's included

• ClickHouse 24.12 columnar engine, single-node configuration, listen_host 0.0.0.0
• HTTP (8123) and native TCP (9000) interfaces
• Unique per-VM password for the default user generated at first boot
• Verified pinned package installs (SHA256-checked)
• Ubuntu 24.04 LTS with automatic security updates
• Trusted Launch: Secure Boot + vTPM supported
• Scales vertically with VM size and Premium SSD v2 throughput

Quick start

1. SSH into the VM with the username and key you chose at deploy.
2. ClickHouse runs as the `clickhouse-server` systemd service, listening on all interfaces (HTTP 8123, native 9000); the in-image ufw allows both — the NSG keeps them closed until you open them.
3. Connect with `clickhouse-client --user default --password "$(sudo cat /var/lib/clickhouse/admin-password)"`, create your first table, and load data via INSERT or the HTTP interface.

Get your admin password (one time)

ssh <your-username>@<VM-IP>
sudo cat /var/lib/clickhouse/admin-password

This is the password of the ClickHouse `default` user, generated at first boot (stored as a SHA-256 hash in /etc/clickhouse-server/users.d/default-password.xml). Create dedicated users and change it before exposing 8123/9000.