We sit down with you and build your perfect lead list. Book a call with founders.

ClickHouse Analysis

What is ClickHouse?

Fast open-source column-oriented database management system

Location
Palo Alto, California, United States
Employees
201-500
Founded
2016
Customer Satisfaction
4.4
Deployment Type
Hybrid
Implementation Complexity
Complex
Initial Price
$66.52
Ongoing Support Cost
$66.52

Product Features & Capabilities

  • ClickHouse Cloud for managed database services
  • Open-source ClickHouse for self-hosted deployments
  • ClickHouse Local for local file queries
  • ClickPipes for data ingestion connectors
  • ClickHouse Keeper for high availability and data consistency.

Other Considerations

Trusted by major companies like Tesla and Lyft; Offers over 100 integrations with various tools; Open-source with a strong developer community.

Key Disadvantages

  • Worse query performance than competitors like TimescaleDB for most queries, except for complex aggregations.
  • Poor insert performance and higher disk usage compared to some competitors (e.g., 2.7x higher disk usage than TimescaleDB).
  • Lack of support for certain SQL queries on materialized views, which may require additional storage.
  • No enforcement of uniqueness, allowing duplicate primary keys to be inserted.
  • Not designed for OLTP workloads, limiting its use as a general-purpose database.

Companies Using Product

1Flow (https://1flow.ai/)
2gis (https://2gis.ru)
3xpl (https://3xpl.com/)
5CNetwork (https://www.5cnetwork.com/)
ABTasty (https://www.abtasty.com/)
Arkhn (https://www.arkhn.com)
ASO.dev (https://aso.dev/)
AdGreetz (https://www.adgreetz.com/)
AdGuard (https://adguard.com/)
AdScribe (http://www.adscribe.tv/)
Adapty (https://adapty.io/)
Adevinta (https://www.adevinta.com/)
Admiral (https://getadmiral.com/)
Admixer (https://admixer.com/)
Aggregations.io (https://aggregations.io/)
Ahrefs (https://ahrefs.com/)
Airfold (https://www.airfold.co/)
Aiven (https://aiven.io/)
Akamai (https://www.akamai.com/)
Akvorado (https://demo.akvorado.net/)
Alauda (https://alauda.io)
AlgoNode (https://algonode.io/)
Alibaba Cloud (https://cn.aliyun.com/)
Aloha Browser (https://alohabrowser.com/)
Altinity (https://altinity.com/)
Amadeus (https://amadeus.com/)
AMP (https://useamp.com/)
Android Hub (https://bestforandroid.com/)
AnswerAI (https://www.answerai.co.uk/)
Anton (https://anton.tools/)
Antrea (https://antrea.io/)
ApiRoad (https://apiroad.net/)
Apitally (https://apitally.io/)
Appsflyer (https://www.appsflyer.com)
Aptabase (https://aptabase.com/)
ArenaData (https://arenadata.tech/)
Argedor (https://www.argedor.com/en/clickhouse/)
Atani (https://atani.com/en/)
Attentive (https://www.attentive.com/)
Astronomer (https://www.astronomer.io/)
Autoblocks (https://autoblocks.ai)
Aviso (https://www.aviso.com/)
Avito (https://avito.ru/)
Axis Communications (https://www.axis.com/en-ca)
AzurePrice (https://azureprice.net/)
AzurGames (https://azurgames.com/)
B2Metric (https://b2metric.com/)
BIGO (https://www.bigo.sg/)
Badoo (https://badoo.com)
Baidu (https://www.baidu.com/)
Baselime (https://baselime.io/)
Basic RUM (https://www.basicrum.com/)
Beehiiv (https://www.beehiiv.com/)
Beeline (https://beeline.ru/)
Beekeeper (https://www.beekeeper.io/)
Beetested (https://www.beetested.com/)
Benocs (https://www.benocs.com/)
Bento (https://bento.me/en/home)
Better Stack (https://betterstack.com/)
BiliBili (https://www.bilibili.com/)
Binom (https://binom.org/)
Bitquery (https://bitquery.io/)
Bloomberg (https://www.bloomberg.com/)
Bloxy (https://bloxy.info)
Bonree (https://www.bonree.com/)
Bonside (https://www.bonside.com/)
Botify (https://www.botify.com/)
Braintrust (https://www.usebraintrust.com/)
Buildkite (https://buildkite.com/)
ByConity (https://byconity.github.io/)
Bytedance (https://www.bytedance.com)
CARTO (https://carto.com/)
CERN (http://public.web.cern.ch/public/)
CHEQ (https://cheq.ai/)
Campaign Deputy (https://campaigndeputy.com/)
Canopus Networks (https://canopusnetworks.com/)
Capgo.app (https://capgo.app/)
CardsMobile (https://cardsmobile.ru/)
Castle (https://castle.io/)
Cato Networks (https://www.catonetworks.com/)
CDN77 (https://www.cdn77.com/)
Chainbase (https://chainbase.online/)
ChatLayer (https://chatlayer.ai/)
Checkly (https://www.checklyhq.com/)
ChelPipe Group (https://chelpipegroup.com/)
Chroma (https://www.trychroma.com/)
CipherStash (https://cipherstash.com/)
Cisco (http://cisco.com/)
Citadel Securities (https://www.citadelsecurities.com/)
Citymobil (https://city-mobil.ru)
Clearbit (https://clearbit.com/)
ClickFunnels (https://www.clickfunnels.com/)
ClickVisual (https://clickvisual.net/)
Clog (https://www.hybridlogic.co.uk/)
Cloud Circus, Inc. (https://cloudcircus.jp/)
Cloudflare (https://cloudflare.com)
CloudRaft (https://www.cloudraft.io/)
Codegiant (https://codegiant.io/)
Cognitiv (https://cognitiv.ai/)
Coinhall (https://coinhall.org/)
Coinpaprika (https://coinpaprika.com/)
Comcast (https://corporate.comcast.com/)
Common Room (https://www.commonroom.io/)
Constructor (https://constructor.io/)
Contentsquare (https://contentsquare.com)
Coroot (https://coroot.com/)
Corsearch (https://corsearch.com/)
Corunet (https://coru.net/)
Covalent (https://www.covalenthq.com/)
CraiditX (https://www.creditx.com)
Craigslist (https://sfbay.craigslist.org/)
Crazypanda (https://crazypanda.ru/en/)
Criteo (https://www.criteo.com/)
Cryptology (https://cryptology.com/)
Culver Max Entertainment/Sony Pictures (https://www.sonypicturesnetworks.com/overview)
Cumul.io (https://www.cumul.io)
DB Pilot (https://www.dbpilot.io/)
DENIC (https://www.denic.de/)
DNSMonster (https://dnsmonster.dev/)
Darwinium (https://www.darwinium.com/)
Dash0 (https://www.dash0.com/)
Dashdive (https://www.dashdive.com/)
Dassana (https://lake.dassana.io/)
Datafold (https://www.datafold.com/)
Dataliance for China Telecom (https://www.chinatelecomglobal.com/)
DeepFlow (https://deepflow.io)
DeepL (https://www.deepl.com/)
Deepglint (https://www.deepglint.com/)
Deeplay (https://deeplay.io/eng/)
Depot (https://depot.dev/)
Deutsche Bank (https://db.com)
DevHubStack (http://devhubstack.com/)
Didi (https://web.didiglobal.com/)
DigiCert (https://www.digicert.com)
Disney+ (https://www.disneyplus.com/)
Dittofeed (https://dittofeed.com/)
Diva-e (https://www.diva-e.com)
Dolphin Emulator (https://dolphin-emu.org/)
DoorDash (https://www.doordash.com/home)
Dopple.io (https://dolphin-emu.org/)
DotSentry (https://forum.polkadot.network/t/dotsentry-ecosystem-wide-monitoring-solution/8210)
DrDroid (https://www.drdroid.io/)
Duckbill Group (https://www.duckbillgroup.com/)
eBay (https://www.ebay.com/)
Ecommpay (https://ecommpay.com/)
Ecwid (https://www.ecwid.com/)
Effodio (https://www.effodio.com/)
Egg (https://github.com/ducc/egg)
Electrum (https://www.electrum.id/)
Embrace (https://embrace.io/)
Ensemble (https://ensembleanalytics.io/)
EventBunker.io (https://www.eventbunker.io/)
ExitLag (http://www.exitlag.com/)
Exness (https://www.exness.com/)
Explo (https://www.explo.co/)
Fastly (https://www.fastly.com/)
FastNetMon (https://fastnetmon.com/)
Fastnear (https://fastnear.com/)
FeatBit (https://www.featbit.co/)
FinBox (https://finbox.in/)
Fingerprint (https://fingerprint.com/)
Firebolt (https://www.firebolt.io/)
Fl0 (https://www.fl0.com/)
Flipkart (https://www.flipkart.com/)
Flipt (https://www.flipt.io/)
Flock Safety (https://www.flocksafety.com/)
FortiSIEM (https://www.fortinet.com/)
Fortis Games (https://fortisgames.com/)
Foxway (https://www.foxway.com/en/)
Friendly Captcha (https://friendlycaptcha.com)
FunCorp (https://fun.co/rp)
Futurra Group (https://futurragroup.com/)
G-Core Labs (https://gcorelabs.com/)
Galaxy-Future (https://www.galaxy-future.com/en/home)
Geniee (https://geniee.co.jp)
Genotek (https://www.genotek.ru/)
Gigapipe (https://gigapipe.com/)
Gigasheet (https://gigasheet.co/)
GitLab (https://gitlab.com/)
Glaber (https://glaber.io/)
Glenrose Group (https://www.glenrosegroup.com/)
Gluten (https://github.com/oap-project/gluten)
Goldsky (https://goldsky.com/)
Good Job Games (https://goodjobgames.com/)
Goodpeople (https://twitter.com/_suzychoi/status/1702113350258180245)
Gorgias (https://www.gorgias.com/)
Grafbase (https://grafbase.com/)
GraphCDN (https://graphcdn.io/)
GraphJSON (https://www.graphjson.com)
GraphQL Hive (https://graphql-hive.com/)
Groundcover (https://groundcover.com/)
Grouparoo (https://www.grouparoo.com)
Growthbook (https://www.growthbook.io)
Gumlet (https://www.gumlet.com/)
Harvey (https://www.harvey.ai/)
HUYA (https://www.huya.com/)
Highlight (https://www.highlight.io/)
HockeyStack (https://hockeystack.com/)
Honeybadger (https://www.honeybadger.io/)
Hookdeck (https://hookdeck.com/)
Hopsteiner (https://www.hopsteiner.com/)
Horizon (https://horizon.io/)
Huawei (https://www.huaweicloud.com/intl/en-us/)
Hubalz (https://hubalz.com)
Huntress (https://www.huntress.com)
Hydrolix (https://www.hydrolix.io/)
HyperDx (https://www.hyperdx.io/)
Hystax (https://hystax.com)
IBM (https://www.ibm.com)
IBM QRadar (https://www.ibm.com)
ICA (https://www.the-ica.com/)
Idealista (https://www.idealista.com)
Improvado (https://improvado.io/)
INCREFF (https://www.increff.com/)
Inigo (https://inigo.io/)
Infobaleen (https://infobaleen.com)
Infovista (https://www.infovista.com/)
Inngest (https://www.inngest.com/)
InnoGames (https://www.innogames.com)
Instabug (https://instabug.com/)
Instacart (https://instacart.com/)
Instana (https://www.instana.com)
Integros (https://integros.com)
inwt (https://www.inwt-statistics.com/)
Ippon Technologies (https://ippon.tech)
Ivi (https://www.ivi.ru/)
Jerry (https://getjerry.com/)
Jinshuju (https://jinshuju.net)
Jitsu (https://jitsu.com)
JuiceFS (https://juicefs.com/)
Jump Capital (https://jumpcap.com/)
Jump Trading (https://www.jumptrading.com/)
June (https://www.june.so/)
Juspay (https://juspay.in/)
KGK Global (https://www.kgk-global.com/en/)
KMK Online (https://www.kmkonline.co.id/)
Kaiko (https://www.kaiko.com/)
Kakaocorp (https://www.kakaocorp.com/)
Kami (https://www.kamiapp.com/)
Klaviyo (https://www.klaviyo.com/)
Knock.app (https://knock.app/)
Kodiak Data (https://www.kodiakdata.com/)
Kontur (https://kontur.ru)
Kopo Kopo (https://kopokopo.co.ke/)
Kuaishou (https://www.kuaishou.com/)
Kujiale (https://www.kujiale.com/)
Kyligence (https://kyligence.io/)
LANCOM Systems (https://www.lancom-systems.com/)
Langchain (https://www.langchain.com/)
Langtrace AI (https://www.langtrace.ai/)
Lago (https://www.getlago.com/)
Lagon (https://lagon.app/)
Last9 (https://last9.io/)
Laudspeaker (https://laudspeaker.com/)
Lawrence Berkeley National Laboratory (https://www.lbl.gov)
Lever (https://www.lever.co/)
LifeStreet (https://lifestreet.com/)
LimeChat (https://www.limechat.ai/)
LINE Digital Frontier (https://ldfcorp.com/ja)
LiteLLM (https://github.com/BerriAI/litellm)
Little Red Book (Xiaohongshu) (http://www.xiaohongshu.com/)
LogfireAI (https://logfire.ai/)
LogSnag (https://logsnag.com/)
Logtail (https://betterstack.com/logtail)
Loja Integrada (https://lojaintegrada.com.br/)
Lookforsale (https://lookforsale.ru/)
Loopme (https://loopme.com/)
Luabase (https://luabase.com/)
Lyft (https://lyft.com)
MAXILECT (https://maxilect.com/)
MGID (https://www.mgid.com/)
MUX (https://mux.com/)
Mail.ru Cloud Solutions (https://mcs.mail.ru/)
Marfeel (https://www.marfeel.com/)
Marilyn (https://tech.mymarilyn.ru)
MasMovil (https://www.masmovil.es/)
Match Systems (https://matchsystems.com/)
Mello (https://mellodesign.ru/)
Memfault (https://https://memfault.com/)
cBioPortal (https://www.cbioportal.org/)
MessageBird (https://www.messagebird.com)
Metoda (https://metoda.com/)
MetricFire (https://www.metricfire.com)
Microsoft - Clarity (https://clarity.microsoft.com/)
Microsoft - Titan (https://www.microsoft.com/)
Middleware (https://middleware.io/)
MindsDB (https://www.mindsdb.com/)
Modeo (https://modeo.ai/)
moosejs (https://www.moosejs.com/)
Motodata (https://www.motodata.com/)
Muse Group (https://mu.se/)
MyScale (https://myscale.com/)
NANO Corp (https://nanocorp.fr/en/)
NGINX (https://nginx.com/)
NIC Labs (https://niclabs.cl/)
Nixys (https://nixys.io/)
NLMK (https://nlmk.com/en/)
NOC Project (https://getnoc.com/)
Nansen (https://www.nansen.ai/)
Narrative (https://www.trynarrative.com/)
Nationale Databank Wegverkeers (https://www.ndw.nu/)
Nebius (https://nebius.com/il/docs/managed-clickhouse/)
Neocom (https://www.neocom.ai/)
NeonDB (https://neon.tech/)
NetMeta (https://github.com/monogon-dev/NetMeta/blob/main/README.md)
Netflix (https://www.netflix.com/)
Netskope (https://www.netskope.com/)
Nexpath Networks (https://www.nexpath.net/)
NineData (https://www.ninedata.cloud/)
Noction (https://www.noction.com)
Notionlytics (https://notionlytics.com/)
Ntop (https://www.ntop.org/)
Nuna Inc. (https://www.nuna.com/)
Nutanix (https://www.nutanix.com/)
Oden (https://oden.io/)
Odoscope (https://www.odoscope.com/)
Ok.ru (https://ok.ru)
Omnicomm (https://omnicomm.ru/)
OneAPM (https://www.oneapm.com/)
One Fact Foundation (https://www.onefact.org/)
OneUptime (https://oneuptime.com/)
Onepixel.link (https://onepixel.link/)
Ongage (https://www.ongage.com/)
Ookla (https://www.ookla.com/)
OONI (https://ooni.org/)
Open Targets (https://www.opentargets.org/)
OpenLIT (https://openlit.io/)
OpenMeter (https://openmeter.io)
OpenReplay (https://openreplay.com/)
Opensee (https://opensee.io/)
Oppo (https://www.oppo.com/cn/)
OpsVerse (https://opsverse.io/)
Opstrace (https://opstrace.com/)
Oxide (https://oxide.computer/)
OZON (https://corp.ozon.com/)
PITS Globale Datenrettungsdienste (https://www.pitsdatenrettung.de/)
PRANA (https://prana-system.com/en/)
Pace (https://www.paceapp.com/)
Panelbear (https://panelbear.com/)
Papermark (https://www.papermark.io/)
Percent (https://www.percent.cn/)
Percona (https://www.percona.com/)
Phare (https://phare.io/)
PheLiGe (https://phelige.com/)
PingCAP (https://pingcap.com/)
Pirsch (https://pirsch.io/)
Piwik PRO (https://piwik.pro/)
Plane (https://plane.so/)
Plausible (https://plausible.io/)
PoeticMetric (https://www.poeticmetric.com/)
Portkey AI (https://portkey.ai/)
PostHog (https://posthog.com/)
Postmates (https://postmates.com/)
Pragma Innovation (http://www.pragma-innovation.fr/)
Prefect (https://www.prefect.io/)
Propel (https://www.propeldata.com/)
Property Finder (https://www.propertyfinder.com/)
QINGCLOUD (https://www.qingcloud.com/)
Qrator (https://qrator.net)
Qualified (https://www.qualified.com/)
Qube Research & Technologies (https://www.qube-rt.com/)
QuickCheck (https://quickcheck.ng/)
R-Vision (https://rvision.pro/en/)
RELEX (https://relexsolutions.com)
Raiffeisenbank (https://www.rbinternational.com/)
Railway (https://railway.app/)
Rambler (https://rambler.ru)
Ramp (https://ramp.com/)
Rapid Delivery Analytics (https://rda.team/)
Real Estate Analytics (https://rea-global.com/)
Releem (https://releem.com/)
Replica (https://replicahq.com)
Request Metrics (https://requestmetrics.com/)
Rengage (https://rengage.ai/)
Resmo (https://replicahq.com)
Retell (https://retell.cc/)
Rivet (https://rivet.gg/)
Roblox (https://www.roblox.com/)
Rokt (https://www.rokt.com/)
Rollbar (https://www.rollbar.com)
Rspamd (https://rspamd.com/)
RuSIEM (https://rusiem.com/en)
RunReveal (https://runreveal.com/)
S7 Airlines (https://www.s7.ru)
SEMrush (https://www.semrush.com/)
SESCO Trading (https://www.sescotrading.com/)
SGK (http://www.sgk.gov.tr/wps/portal/sgk/tr)
SMI2 (https://smi2.ru/)
SQLPad (https://getsqlpad.com/en/introduction/)
Santiment (https://www.santiment.net)
Sber (https://www.sberbank.com/index)
Scale8 (https://scale8.com)
Scarf (https://about.scarf.sh/)
Scireum GmbH (https://www.scireum.de/)
ScrapingBee (https://www.scrapingbee.com/)
ScratchDB (https://scratchdb.com/)
Segment (https://segment.com/)
sembot.io (https://sembot.io/)
Sendinblue (https://www.sendinblue.com/)
Sentio (https://www.sentio.xyz/)
Sentry (https://sentry.io/)
seo.do (https://seo.do/)
Serif Health (https://www.serifhealth.com/)
Serverless (https://www.serverless.com/)
ServiceNow (https://www.servicenow.com/)
Sewer AI (https://www.sewerai.com/)
Shopee (https://www.shopee.com/)
SigNoz (https://signoz.io/)
Sina (http://english.sina.com/index.html)
Sinch (https://www.sinch.com/)
Sipfront (https://www.sipfront.com/)
SiteBehaviour Analytics (https://www.sitebehaviour.com/)
Skool (https://www.skool.com/)
slido (https://www.slido.com/)
Solarwinds (https://www.solarwinds.com/)
Sonrai Security (https://sonraisecurity.com/)
Spark New Zealand (https://www.spark.co.nz/)
Spec (https://www.specprotected.com/)
spectate (https://spectate.net/)
Splio (https://www.splio.com/en/)
Splitbee (https://splitbee.io)
Splunk (https://www.splunk.com/)
Spotify (https://www.spotify.com)
Staffbase (https://staffbase.com/en/)
Staffcop (https://www.staffcop.ru/)
Statsig (https://statsig.com/)
Streamkap (https://streamkap.com/)
Suning (https://www.suning.com/)
Superology (https://superology.com/)
Superwall (https://superwall.me/)
SwarmFarm Robotics (https://www.swarmfarm.com/)
Swetrix (https://swetrix.com)
Swift Navigation (https://www.swiftnav.com/)
Synerise (https://synerise.com/)
Synpse (https://synpse.net/)
Synq (https://www.synq.io)
sumsub (https://sumsub.com/)
Talo Game Services (https://trytalo.com)
Tasrie IT Services (https://tasrieit.com)
TURBOARD (https://www.turboard.com/)
TeamApt (https://www.teamapt.com/)
Teamtailor (https://www.teamtailor.com/en/)
Tekion (https://tekion.com/)
Temporal (https://www.tencentmusic.com/)
Tencent Music Entertainment (TME) (https://www.tencentmusic.com/)
Tencent (https://www.tencent.com)
Teralytics (https://www.teralytics.net/)
Tesla (https://www.tesla.com/)
The Guild (https://the-guild.dev/)
Theia (https://theia.so/)
ThirdWeb (https://thirdweb.com/)
Timeflow (https://timeflow.systems)
Timeplus (https://www.timeplus.com/)
Tinybird (https://www.tinybird.co/)
TrackingPlan (https://www.trackingplan.com/)
Traffic Stars (https://trafficstars.com/)
Trillabit (https://www.trillabit.com/home)
Trip.com (https://trip.com/)
Turkcell (https://www.turkcell.com.tr/)
Tweeq (https://tweeq.sa/en)
Twilio (https://www.twilio.com)
Tydo (https://www.tydo.com)
URLsLab (https://www.urlslab.com/)
UTMSTAT (https://hello.utmstat.com/)
Uber (https://www.uber.com)
Uptrace (https://uptrace.dev/)
UseTech (https://usetech.com/)
Usermaven (https://usermaven.com/)
VKontakte (https://vk.com)
VKontech (https://vkontech.com/)
VMware (https://www.vmware.com/)
Valueleaf Services Pvt.Ltd (http://valueleaf.com/)

Market Position

  1. Performance - ClickHouse is optimized for Online Analytical Processing (OLAP), allowing it to execute complex queries on large datasets with sub-second response times. It can handle terabyte-level data and return complex aggregations in milliseconds, significantly outperforming competitors like Snowflake, which may take dozens of seconds for similar queries.
  2. Scalability - The platform is designed to scale efficiently, enabling users to process vast amounts of data without compromising performance.
  3. Cost-Effectiveness - ClickHouse offers a more affordable solution compared to traditional data warehouses, making it an attractive option for companies looking to optimize their data analytics costs.
  4. Open Source - Being an open-source solution, ClickHouse allows for greater flexibility and customization, appealing to organizations that prefer to tailor their data solutions to specific needs.
  5. Real-Time Analytics - ClickHouse is particularly well-suited for real-time analytics, which is increasingly important for businesses that rely on timely data insights for decision-making.

Key Advantages

  • High performance: ClickHouse can be 2 to 10 times faster than many competitors for analytical queries.
  • Cost-effective: ClickHouse Cloud is 3-5x more cost-effective than alternatives like Snowflake.
  • Scalability: Its MPP architecture allows for horizontal scaling, making it suitable for large-scale analytics.
  • Open-source: Being open-source provides flexibility and community support.
  • Efficient data compression: This reduces storage costs while enabling rapid data retrieval.

Find more companies like ClickHouse

Databricks Competitors