<!-- mobian-agent-page publisher="dailydev" canonical="https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn" -->

---
title: The official ClickHouse provider for Apache Airflow is...
description: ClickHouse has released an official Apache Airflow provider (apache-airflow-providers-clickhousedb), replacing the community-maintained...
canonical: https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn
twitter:card: summary_large_image
twitter:site: @dailydotdev
og:type: website
og:site_name: daily.dev
og:title: The official ClickHouse provider for Apache Airflow is now available | daily.dev
og:description: ClickHouse has released an official Apache Airflow provider (apache-airflow-providers-clickhousedb), replacing the community-maintained...
og:url: https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn
og:image: https://api.daily.dev/og/posts/af5fk9KrN.png
og:image:alt: The official ClickHouse provider for Apache Airflow is now available
og:image:width: 1200
og:image:height: 630
og:locale: en
---

> ## Documentation Index
> Fetch the complete documentation index at: https://daily.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# The official ClickHouse provider for Apache Airflow is now available

**[ClickHouse](https://daily.dev/sources/clickhouse)** · 7 min read · 1 upvotes · 0 comments

## Summary

ClickHouse has released an official Apache Airflow provider (apache-airflow-providers-clickhousedb), replacing the community-maintained airflow-clickhouse-plugin as the recommended integration path. It connects over HTTP(S) using the clickhouse-connect Python client, integrates with Airflow's common SQL operators (SQLExecuteQueryOperator), and includes a ClickHouseHook for bulk inserts and other client-specific operations. The post walks through installation for both self-managed Airflow and Astronomer's managed platform, including connection configuration, a sample DAG, and bulk insert usage via the hook. It also highlights production usage examples, including ClickHouse's own 76-DAG internal data warehouse and Astronomer's own Astro Observe product built on ClickHouse Cloud.

## Full article

daily.dev links to this article rather than hosting it. Read it at the original source: <https://clickhouse.com/blog/clickhouse-airflow-provider>

## Questions this post answers

### Is there an official Apache Airflow provider for ClickHouse now?

Yes, apache-airflow-providers-clickhousedb is the official upstream provider, installable via pip. It connects over HTTP(S) using the clickhouse-connect Python client, works with Airflow's common SQLExecuteQueryOperator for DDL/DML/analytical queries, and includes a ClickHouseHook with a bulk_insert_rows method for native columnar bulk inserts.

_Track new database integrations like this ClickHouse Airflow provider as they land, on daily.dev._

### Should I migrate from the airflow-clickhouse-plugin to the official ClickHouse Airflow provider?

Yes, migrating to apache-airflow-providers-clickhousedb is recommended since it's now the officially maintained integration where ClickHouse's investment and new features will land going forward. The move is mostly mechanical: install the provider, point the connection at the HTTP(S) port, and use the standard SQLExecuteQueryOperator instead of the community plugin's custom operators.

_Compare community versus official integrations before migrating pipelines, with daily.dev._

### How do I configure a ClickHouse connection for Airflow on Astronomer's Astro platform?

Install the apache-airflow-providers-clickhousedb package via requirements.txt, then create a connection of type 'clickhouse' either in the Airflow UI or through Astro's Environment Manager, which stores credentials in a managed secrets backend shared across deployments. Use port 8443 and set secure to true for TLS-enabled ClickHouse Cloud clusters; astro deploy ships the same setup to production unchanged.

_Follow setup guides for Astronomer and ClickHouse pipelines as tooling evolves, via daily.dev._

## Similar posts on daily.dev

- [ClickHouse is now available on the dbt platform](https://daily.dev/posts/clickhouse-is-now-available-on-the-dbt-platform-b5jjgg1uo) · ClickHouse · 1 upvotes · 0 comments
- [Managed Apache Airflow: Scaling Data & AI Workloads](https://daily.dev/posts/managed-apache-airflow-scaling-data-ai-workloads-1s4kat53h) · Google Cloud · 0 upvotes · 0 comments
- [The open ecosystem around ClickHouse](https://daily.dev/posts/the-open-ecosystem-around-clickhouse-omxawseza) · ClickHouse · 0 upvotes · 0 comments
- [ClickHouse and Apache Iceberg: A Practical Guide to Data Lakehouse Integration](https://daily.dev/posts/clickhouse-and-apache-iceberg-a-practical-guide-to-data-lakehouse-integration-fhwzab4sv) · BigData Boutique blog · 0 upvotes · 0 comments

---

Tags: [#python](https://daily.dev/tags/python), [#clickhouse](https://daily.dev/tags/clickhouse), [#apache-airflow](https://daily.dev/tags/apache-airflow)

[View this post on daily.dev](https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn)

```json
{"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]}
{"@context":"https://schema.org","@type":"TechArticle","headline":"The official ClickHouse provider for Apache Airflow is now available","url":"https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn"},"datePublished":"2026-09-17T18:09:37.708Z","dateModified":"2026-09-17T19:34:14.614Z","description":"ClickHouse has released an official Apache Airflow provider (apache-airflow-providers-clickhousedb), replacing the community-maintained...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cac515f38603e05cc3eded5c2629bdf0?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/cac515f38603e05cc3eded5c2629bdf0?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"ClickHouse","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"ClickHouse","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/clickhouse","url":"https://daily.dev/sources/clickhouse"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":1},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"python,clickhouse,apache-airflow","timeRequired":"PT7M"}
{"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"ClickHouse","item":"https://daily.dev/sources/clickhouse"},{"@type":"ListItem","position":3,"name":"The official ClickHouse provider for Apache Airflow is now available"}]}
{"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/the-official-clickhouse-provider-for-apache-airflow-is-now-available-af5fk9krn#faq","mainEntity":[{"@type":"Question","name":"Is there an official Apache Airflow provider for ClickHouse now?","acceptedAnswer":{"@type":"Answer","text":"Yes, apache-airflow-providers-clickhousedb is the official upstream provider, installable via pip. It connects over HTTP(S) using the clickhouse-connect Python client, works with Airflow's common SQLExecuteQueryOperator for DDL/DML/analytical queries, and includes a ClickHouseHook with a bulk_insert_rows method for native columnar bulk inserts. Track new database integrations like this ClickHouse Airflow provider as they land, on daily.dev."}},{"@type":"Question","name":"Should I migrate from the airflow-clickhouse-plugin to the official ClickHouse Airflow provider?","acceptedAnswer":{"@type":"Answer","text":"Yes, migrating to apache-airflow-providers-clickhousedb is recommended since it's now the officially maintained integration where ClickHouse's investment and new features will land going forward. The move is mostly mechanical: install the provider, point the connection at the HTTP(S) port, and use the standard SQLExecuteQueryOperator instead of the community plugin's custom operators. Compare community versus official integrations before migrating pipelines, with daily.dev."}},{"@type":"Question","name":"How do I configure a ClickHouse connection for Airflow on Astronomer's Astro platform?","acceptedAnswer":{"@type":"Answer","text":"Install the apache-airflow-providers-clickhousedb package via requirements.txt, then create a connection of type 'clickhouse' either in the Airflow UI or through Astro's Environment Manager, which stores credentials in a managed secrets backend shared across deployments. Use port 8443 and set secure to true for TLS-enabled ClickHouse Cloud clusters; astro deploy ships the same setup to production unchanged. Follow setup guides for Astronomer and ClickHouse pipelines as tooling evolves, via daily.dev."}}]}
```

