skillfed

apache-airflow-providers-apache-drill

Provider package apache-airflow-providers-apache-drill for Apache Airflow

apache-airflow-providers-apache-drill v3.3.3 186.5K downloads/30d#9,985 on PyPI46,490
Permissive license Apache-2.0 Active released

What it is and what it does

This is an Apache Airflow provider package that bridges Airflow workflows to Apache Drill, a distributed SQL query engine. It supplies operators, hooks, and connection types for Airflow DAGs to execute SQL queries against Drill clusters and manage those connections within the Airflow ecosystem.

The package depends on apache-airflow (>=2.11.0), the common SQL provider layer (apache-airflow-providers-common-sql >=1.32.0), a compatibility layer (apache-airflow-providers-common-compat >=1.8.0), and sqlalchemy-drill (>=1.1.0 with specific version exclusions). It is maintained as part of the Apache Airflow project, supports Python 3.10 through 3.14, and carries no known security vulnerabilities.

Use it for:

  • Schedule and orchestrate SQL queries against Drill clusters as part of larger Airflow data pipelines.
  • Integrate Drill query results into multi-step ETL workflows with conditional logic and error handling.
  • Monitor and log Drill query execution within Airflow's centralized task tracking and alerting system.
  • Connect Drill to other Airflow providers for cross-system data movement and transformation.
  • Manage Drill connection credentials and configurations through Airflow's connection UI rather than code.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides Apache Airflow integration for Apache Drill, enabling Airflow workflows to connect to and query Drill clusters via SQL operators and hooks.

Yes. This is an active, production-stable provider package maintained by the Apache Airflow project with no known vulnerabilities. Install it if you run Airflow and need to query Apache Drill clusters from your DAGs. The low install friction and permissive Apache license make adoption straightforward; verify that your Airflow version meets the >=2.11.0 requirement and that your sqlalchemy-drill version avoids the excluded 1.1.6 and 1.1.7 releases.

Install

apache-airflow-providers-apache-drill on PyPI

pip

pip install apache-airflow-providers-apache-drill

uv

uv add apache-airflow-providers-apache-drill

poetry

poetry add apache-airflow-providers-apache-drill

Installing apache-airflow-providers-apache-drill

Before you install

Low install friction; pure Python wheel. Active maintenance with recent release (68 days old). Requires apache-airflow >=2.11.0, apache-airflow-providers-common-sql >=1.32.0, apache-airflow-providers-common-compat >=1.8.0, and sqlalchemy-drill >=1.1.0 (excluding 1.1.6 and 1.1.7).

License in practice

Apache License 2.0 (permissive). No restrictions on commercial use, modification, or distribution; standard Apache terms apply.

Quickstart

pip install apache-airflow-providers-apache-drill

from airflow.providers.apache.drill.operators.drill import DrillOperator
from airflow import DAG

with DAG('drill_example') as dag:
    task = DrillOperator(
        task_id='query_drill',
        sql='SELECT * FROM table',
        drill_conn_id='drill_default'
    )

Requires an existing Apache Airflow installation (>=2.11.0) and a configured Drill connection in Airflow.

Verify before relying

  • Specific operators and hooks available beyond the standard SQL provider interface
  • Whether sqlalchemy-drill version constraints (!=1.1.6, !=1.1.7) reflect known bugs or compatibility issues

Package facts

License Apache-2.0 (permissive)
Python support supports the current Python release (>=3.10)
Install friction low — pure-Python wheel
Runtime dependencies 4 — apache-airflow, apache-airflow-providers-common-sql, apache-airflow-providers-common-compat, sqlalchemy-drill
Maintenance actively maintained — 68 days since the last release
Last repo commit
First released
Downloads 186,485/month — #9,985 on PyPI (30-day window, as of 2026-08-14)
Known vulnerabilities none known (OSV.dev, checked 2026-08-14)

Evidence: apache_airflow_providers_apache_drill-3.3.3-py3-none-any.whl

Keywords: airflow-provider, apache.drill, airflow, integration

Development Status :: 5 - Production/StableEnvironment :: ConsoleEnvironment :: Web EnvironmentFramework :: Apache AirflowFramework :: Apache Airflow :: ProviderIntended Audience :: DevelopersIntended Audience :: System AdministratorsProgramming Language :: Python :: 3.10Programming Language :: Python :: 3.11Programming Language :: Python :: 3.12Programming Language :: Python :: 3.13Programming Language :: Python :: 3.14Topic :: System :: Monitoring

Tags

airflow apache drill providerdrill sql integration airflowairflow drill operatorapache drill connector airflowdrill query executor airflowairflow drill hookdrill database airflow
airflow-providerdrill-integrationdata-orchestration

More Monitoring packages

tqdm

Wraps any iterable to display a real-time…

copyleft · top 100 on PyPI

opentelemetry-semantic-conventions

Provides generated Python code for…

permissive · top 100 on PyPI

opentelemetry-sdk

Provides the reference implementation of the…

permissive · top 100 on PyPI

opentelemetry-api

Provides the abstract API and interfaces for…

permissive · top 100 on PyPI

opentelemetry-exporter-otlp-proto-http

Exports OpenTelemetry observability data to an…

permissive · top 1,000 on PyPI

opentelemetry-instrumentation

Provides automatic instrumentation commands and…

permissive · top 1,000 on PyPI

apache-airflow-providers-common-sql

Provides common SQL operators, hooks, and…

permissive · top 1,000 on PyPI

apache-airflow-providers-sqlite

Integrates SQLite databases with Apache Airflow…

permissive · top 5,000 on PyPI

apache-airflow-providers-apache-pinot

Integrates Apache Pinot with Apache Airflow,…

permissive · top 15,000 on PyPI

apache-airflow-providers-odbc

Provides ODBC database connectivity operators…

permissive · top 5,000 on PyPI

apache-airflow-providers-apache-druid

Integrates Apache Druid with Apache Airflow,…

permissive · top 15,000 on PyPI

apache-airflow-providers-apache-impala

Integrates Apache Impala with Apache Airflow,…

permissive · top 5,000 on PyPI

apache-airflow-providers-pgvector

Integrates pgvector operations into Apache…

permissive · top 15,000 on PyPI

apache-airflow-providers-ydb

Integrates YDB (a distributed SQL database)…

permissive · top 15,000 on PyPI

sqlalchemy-drill

SQLAlchemy dialect for Apache Drill that…

permissive · top 5,000 on PyPI

apache-airflow-providers-common-ai

Provides AI/LLM hooks and operators for Apache…

permissive · top 15,000 on PyPI