Melvyn Peignon 🇪🇺 🇫🇷 🇬🇧

We’re excited to announce a new integration between ClickHouse and Microsoft OneLake, powered by OneLake Tables APIs + Apache Iceberg. With this update, you can run lightning-fast queries from ClickHouse directly on Iceberg tables in OneLake - with zero data movement required. clickhouse.com/blog/clickhous… 🚀 Beta in ClickHouse 25.11 (November release) ☁️  Coming to ClickHouse Cloud soon after #MSIgnite @msPartner

@nikgeneburn @DesmondSilvers Curious to know what is the database behind this Grafana Dashboard?

@DesmondSilvers this is matchmaking wait time chart in seconds - no anomalies detected. Current CCU is something around 45k in PvP

This game is legit 50% time spent matching now, what ever changing with matching needs to get changed asap or people are gonna stop playing quick, every other raid is a cheater then its back to 5/6 minute loading screens #EscapefromTarkov

Don't miss @ClickHouseDB + @databricks "better together" talk at Data & AI Summit June 11 @ 4:10pm 👏 databricks.com/dataaisummit/s…

In 2024, one thing became clear: Apache Iceberg and the lakehouse model are shaping the future of data infrastructure. With major moves from Databricks, AWS, GCP, and Snowflake, the question isn’t if but how your data lake and lakehouse should integrate with ClickHouse. clickhou.se/4k9IN4D As your team starts to think about the next evolution of your data stack, here’s how ClickHouse fits in: ⚡ Query Iceberg & Delta without ingestion 📥 Load from S3 with s3queue & ClickPipes 🔍 Federate queries across PostgreSQL, MySQL & more 📚 Iceberg catalog support today, Glue & Unity soon What’s next? – Metadata caching, faster Parquet reads, Iceberg CDC, and full write support for open table formats. Check it out and let us know what you think.

If you love ClickHouse, Iceberg, and Lakehouse, here's something to be excited about! 🚀 We're adding support for Iceberg catalog in ClickHouse! Here's a sneak peek of the Polaris catalog hosted on Snowflake queried by ClickHouse in Iceberg! github.com/ClickHouse/Cli…

@pratikgajjar_in @ClickHouseDB Come see us at the booth!

@ClickHouseDB Soon visiting SF snd reinvent, excited to learn from environment.

Ravi d'avoir échangé sur @ClickHouseDB avec @r_conquet! Au programme: ⚡️ ClickHouse et les besoin de temps-réel 🚀 Migration de Google BigQuery ou Snowflake vers ClickHouse 📊 ClickHouse et l'observabilité 🧊 Les cas d'usage autour d’Iceberg youtu.be/SD1NiG6dk64?si…

@criccomini There are two types of MV in ClickHouse: - synchronous (mv get updated as you are inserting into the source table) - asynchronous (mv get updated automatically at a specific schedule)

Looks like their MVs are just normal MVs... github.com/ClickHouse/Cli… Looks like there's some nuance, though. #materialized-views-and-joins" target="_blank" rel="nofollow noopener">clickhouse.com/blog/using-mat…

Digging into @ClickHouseDB a bit. It seems to fill a similar use case as Druid, Pinot, and Materialize. What are its differentiators? It doesn't have differential data flow (materialize) or startree indexes (pinot). They do have materialized views, though...

Met with the @tripcomgroup in March to learn about their migration from Elasticsearch to ClickHouse. Managing 50 PB of data, their insights are invaluable: Dynamically Updating ORDER BY Key Automatic Query Rewriting Kibana with ClickHouse Worth reading: clickhouse.com/blog/how-trip.…

@krithika_vb @OpenAI @Streamkap @braintrustdata @RillData Impressive lineup!

ClickHouse meetup (standing room only🔥) hosted at the CloudFlare office in San Francisco is starting with an exciting lineup of speakers: @OpenAI @Streamkap @braintrustdata @RillData live 🧵👇

When people ask me, can #clickhouse support this workload? I will now show them this screenshot.

ClickHouse casually inserting 2.60 billion rows per second.

@hupo480550 @red___square @alexxubyte It is used for Observability, here is the talk from Netflix at Monitorama: vimeo.com/843994807

@red___square @alexxubyte What is it used for?

Netflix's Tech Stack. This post is based on research from many Netflix engineering blogs and open-source projects. If you come across any inaccuracies, please feel free to inform us. Mobile and web: Netflix has adopted Swift and Kotlin to build native mobile apps. For its web application, it uses React. Frontend/server communication: GraphQL. Backend services: Netflix relies on ZUUL, Eureka, the Spring Boot framework, and other technologies. Databases: Netflix utilizes EV cache, Cassandra, CockroachDB, and other databases. Messaging/streaming: Netflix employs Apache Kafka and Fink for messaging and streaming purposes. Video storage: Netflix uses S3 and Open Connect for video storage. Data processing: Netflix utilizes Flink and Spark for data processing, which is then visualized using Tableau. Redshift is used for processing structured data warehouse information. CI/CD: Netflix employs various tools such as JIRA, Confluence, PagerDuty, Jenkins, Gradle, Chaos Monkey, Spinnaker, Altas, and more for CI/CD processes. –- Subscribe to our weekly newsletter to get a Free System Design PDF (158 pages): bit.ly/3KCnWXq

@theJayKhatri @ClickHouseDB @highlightio Next time I will try to keep my eyes open!

Some proof (@ClickHouseDB). Peep the @highlightio logo 👀

@az38IMV @ClickHouseDB In the documentation: #with-totals-modifier" target="_blank" rel="nofollow noopener">clickhouse.com/docs/en/sql-re… > This extra row is only produced in JSON*, TabSeparated*, and Pretty* formats These formats are not used by the SQLconsole. Use the ClickHouse client and you should have the Totals.

It is good to see more happening around @ApacheIceberg. @ClickHouseDB integration with Apache Iceberg has been released in 23.2, and we are already seeing a lot of adoption! clickhouse.com/docs/en/engine…

.@CamiloSierrax showing us how to visualize data from @ClickHouseDB in @grafana 👀

@wahmedswl @ClickHouseDB The implementation of SharedMergeTree is best suited for the separated compute and storage environment in ClickHouse Cloud.

@ClickHouseDB @ClickHouseDB Will this be part of the ClickHouse as well or just ClickHouse Cloud?

A table engine built specifically for Cloud, working on top of object storage - introducing SharedMergeTree and lightweight updates for ClickHouse Cloud. clickhouse.com/blog/clickhous…

You can try the SharedMergeTree for free in our cloud: clickhouse.cloud/signIn

@MaxPrilutskiy @tbragin @dalemcdiarmid Well, I'm in Barcelona and always happy to talk about Clickhouse! I don't drink coffee, though, but if you know a place where you can get a coffee and I can get tea, I will be happy to meet up!