Sign inGet started
← Back to all posts

Bringing ClickHouse performance to the comfort of data notebooks

By Lukas Frei

Updated on June 30, 2022

With Deepnote and ClickHouse, data teams can query large data sets, extract relevant data, and analyze and model data — all within the comfort of a notebook.

Illustrative image for blog post

ClickHouse is an open-source OLAP database that's 100-1,000 times faster than traditional databases, allowing users to handle thousands of sub-second queries per second on petabyte-scale datasets.

When we first took ClickHouse for a spin using Deepnote, we were blown away by the performance. After experiencing lightning-fast queries in a notebook environment, we knew we needed to build an integration to bring the power of ClickHouse to Deepnote.

That integration is now here! With Deepnote and ClickHouse, data teams can efficiently query very large data sets, extract relevant data, and start analyzing and modeling data — all within the comfort of the notebook environment.

In this article, we'll walk through what makes this experience so unique and show you how to leverage Deepnote's native ClickHouse integration to perform analytics at scale.

👉 If you’re eager to jump right into the deep end, here's a playground Deepnote notebook with a ClickHouse integration set up for you!

Query with SQL & analyze with Python in one place

⁠Deepnote provides first-class support for SQL. This means you get to query your ClickHouse database right from your notebook. Transitions between Python and SQL are seamless, as there’s no need for a Python connector. With Deepnote, you get all the bells and whistles of a SQL editor right in your notebook, including formatting, autocomplete, and linting.


Using ClickHouse SQL blocks, you can write queries, save the results as pandas DataFrames, and visualize it all in one go. And if you're feeling bold, you can even inject Python variables into your SQL queries with jinjasql. This allows you to build out more complex queries with conditionality, "for" loops, and more. If you'd like to venture beyond SQL, you can also use the automatically stored pandas DataFrame and perform some advanced analytics.

Explore ClickHouse data with no code and a dash of magic

Thanks to some built-in magic, a great deal of the exploratory work in Deepnote happens without writing code. This allows for rapid exploration and prototyping on top of your ClickHouse data. With Deepnote's built-in DataFrame viewer, we can quickly examine the data set for missing values, the most common categorical values, distributions of numeric columns, and more. The built-in filters and sorting make it easy to gain a deeper understanding of the data and relationships that might impact our future model's predictions.


Built-in no-code charts allow us to examine our target variable as a function of other features without having to write any additional code. We can seamlessly switch from code to visualizations and go right back into querying as needed.

Present your insights

If you want to turn your queries, code, and charts into impactful data products, ClickHouse and Deepnote have you covered. While you can easily share your notebook with one click, you can go a step further and make your work more accessible and interactive for anyone, all without code.


The goal is to turn your notebook into a simple-yet-powerful data app. You can do so by parameterizing your notebook to introduce interactive user inputs and schedule notebooks so that you're always pulling in fresh data from ClickHouse. Once that's done, all you need to is publish your work.

Keep your ClickHouse data secure

With Deepnote’s native ClickHouse integration, your connection is always secure and allows you to easily query data without exposing confidential information. You can configure the connection at the workspace level and decide whether to make it available to all members and shared projects or just a specific project. As soon as the connection is set up, your ClickHouse data is safeguarded and you don’t have to worry about reconfiguring things again.

👉 Connect to your own ClickHouse instance using the Integrations menu within your Deepnote workspace or just use the playground credentials in our template.


In our workflow, we used a Deepnote notebook as a control plane for our ClickHouse instance. If we wanted to create a fully closed loop, we could have pulled the data into Deepnote to train a machine learning model. From there, we'd deploy our model back into ClickHouse while using Deepnote's data apps to visualize and share the results.

To start using ClickHouse and Deepnote together, create a free Deepnote account or head over to our ClickHouse docs.

Lukas Frei

Product Management Associate @ Deepnote

Follow Lukas on LinkedIn and GitHub


Illustrative image for blog post

Beyond AI chatbots: how we tripled engagement with Deepnote AI

By Gabor Szalai

Updated on April 3, 2024

That’s it, time to try Deepnote

Get started – it’s free
Book a demo



  • Integrations
  • Pricing
  • Documentation
  • Changelog
  • Security




  • Privacy
  • Terms

© Deepnote