Sold by: cloudimg
Deployed on AWS
Free Trial
AWS Free Tier
This product has charges associated with it for seller support. ClickHouse, the open source column oriented analytics database, preinstalled with the HTTP interface and the native TCP protocol enabled. A per instance default user password is generated on first boot. Backed by 24/7 cloudimg support.
Overview
Image
ClickHouse /play SQL playground
Image
clickhouse-client query session
Image
clickhouse-server version
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Overview ClickHouse is the open source column oriented online analytical processing database built for very fast queries over very large amounts of data. It is used for real time analytics, log and event analysis, business intelligence, observability and large scale reporting. This image delivers ClickHouse fully installed and configured, so an analytics database is running within minutes of launch. The current stable line is provided.
What Is Included ClickHouse server and the clickhouse client command line tool, installed from the official ClickHouse package repository, running as a single node. The HTTP interface (which also serves the built in /play SQL playground), the native TCP protocol and the inter server replication port are all configured. ClickHouse is the only workload on the image, so the platform stays lean and predictable.
Authentication Enabled By Default The image ships with the default user locked behind a password placeholder. The first boot service rotates that password to a fresh per instance value and applies it inside ClickHouse with ALTER USER, so the database never accepts an unauthenticated connection.
Secure First Boot On the first boot of your instance a one shot service generates a strong default user password, unique to that instance, writes the plaintext to a file that only the root user can read, and updates ClickHouse with the new credential. No shared or default database credentials ship in the image.
Data On Its Own Volume ClickHouse data, metadata and system tables live on a dedicated, independently resizable storage volume mounted at the ClickHouse data directory. Database files are kept separate from the operating system disk so storage can be grown, snapshotted and backed up on its own schedule.
Ready To Use The ClickHouse service, data directory, configuration and default user are all configured. Connect over SSH, read the generated default user password, and run queries from the clickhouse client shell or any HTTP client. The HTTP /play page exposes a minimal browser SQL playground for ad hoc queries. The user guide explains how to create databases and tables and how to scale out to a multi node cluster.
cloudimg Support 24/7 technical support by email and chat. Help with ClickHouse deployment, cluster expansion, schema design, query tuning and database administration.
Use Cases Real time analytics dashboards and product telemetry. Log, event and observability stores. Business intelligence and ad hoc reporting over very large data sets. Time series and clickstream analysis.
All product and company names are trademarks or registered trademarks of their respective holders. Use of them does not imply any affiliation with or endorsement by them.
Highlights
- ClickHouse preinstalled and ready, with the HTTP interface, the native TCP protocol and the built in /play SQL playground configured on a single node, with no manual setup required
- Password authentication is enforced for the default user and a fresh per instance default user password is generated on first boot and stored in a file only the root user can read
- ClickHouse data lives on a dedicated, independently resizable storage volume, and 24/7 technical support from cloudimg covers deployment, cluster expansion, schema design and query tuning
Details
Sold by
Categories
Delivery method
Delivery option
64-bit (x86) Amazon Machine Image (AMI)
Latest version
Operating system
Ubuntu 24.04
Deployed on AWS
New
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
AWS Marketplace now accepts line of credit payments through the PNC Vendor Finance program. This program is available to select AWS customers in the US, excluding NV, NC, ND, TN, & VT.
Pricing
Free trial
Try this product free for 7 days according to the free trial terms set by the vendor. Usage-based pricing is in effect for usage beyond the free trial terms. Your free trial gets automatically converted to a paid subscription when the trial ends, but may be canceled any time before that.
Pricing is based on actual usage, with charges varying according to how much you consume. Subscriptions have no end date and may be canceled any time. Alternatively, you can pay upfront for a contract, which typically covers your anticipated usage for the contract duration. Any usage beyond contract will incur additional usage-based costs.
Additional AWS infrastructure costs may apply. Use the AWS Pricing Calculator to estimate your infrastructure costs.
If you are an AWS Free Tier customer with a free plan, you are eligible to subscribe to this offer. You can use free credits to cover the cost of eligible AWS infrastructure. See AWS Free Tier for more details. If you created an AWS account before July 15th, 2025, and qualify for the Legacy AWS Free Tier, Amazon EC2 charges for Micro instances are free for up to 750 hours per month. See Legacy AWS Free Tier for more details.
Dimension | Description | Cost/hour |
|---|---|---|
m5.large Recommended | m5.large | $0.08 |
t2.micro | t2.micro instance type | $0.04 |
t3.micro | t3.micro instance type | $0.04 |
d3.4xlarge | d3.4xlarge instance type | $0.24 |
t3.small | t3.small instance type | $0.04 |
m5ad.8xlarge | m5ad.8xlarge instance type | $0.24 |
c8ine.8xlarge | c8ine.8xlarge instance type | $0.24 |
g6.4xlarge | g6.4xlarge instance type | $0.24 |
z1d.6xlarge | z1d.6xlarge instance type | $0.24 |
r6a.48xlarge | r6a.48xlarge instance type | $0.24 |
Vendor refund policy
Refunds available on request.
Legal
Vendor terms and conditions
Upon subscribing to this product, you must acknowledge and agree to the terms and conditions outlined in the vendor's End User License Agreement (EULA) .
Content disclaimer
Vendors are responsible for their product descriptions and other product content. AWS does not warrant that vendors' product descriptions or other product content are accurate, complete, reliable, current, or error-free.
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Initial release of the ClickHouse image.
Additional details
Usage instructions
Connect via SSH on port 22 as the default login user for your operating system variant (the user guide lists it per variant). ClickHouse listens for the native protocol on port 9000 and the HTTP interface on port 8123 on the instance. Retrieve the generated default user password with: sudo cat /root/clickhouse-credentials.txt. Open the shell with: clickhouse-client --password '<password>'. To use the browser SQL playground, restrict port 8123 to trusted networks, then browse to http://<instance-public-ip>:8123/play and sign in as default. The user guide explains how to create databases and tables and how to add further nodes for a multi node cluster.
Resources
Vendor resources
Support
Vendor support
cloudimg provides 24/7 technical support for this product by email and live chat. Our engineers help with deployment, configuration, updates, performance tuning and troubleshooting; critical issues receive a one hour average response. Contact support@cloudimg.co.uk .
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.
Similar products
ClickHouse connector for AWS Glue, built on DataSourceV2 API.
ClickHouse Cloud is an extraordinarily fast, seamlessly scalable and delightfully easy-to-use online analytical database. Start today and receive $300 in free credits.
ClickHouse Cloud is an extraordinarily fast, seamlessly scalable and delightfully easy-to-use online analytical database. Start today and receive $300 in free credits.
Up-to-date and secure image. ClickHouse is an open-source column-oriented OLAP database management system. Use it to boost your database performance while providing linear scalability and hardware efficiency.
ClickHouse Cloud is an extraordinarily fast, seamlessly scalable and delightfully easy-to-use online analytical database.
Customer reviews
No customer reviews yet
Be the first to review this product . We've partnered with PeerSpot to gather customer feedback. You can share your experience by writing or recording a review, or scheduling a call with a PeerSpot analyst.