---
id: apache-airflow-providers-vertica
version: "4.4.0"
license: Apache-2.0
license_treatment: permissive
maintenance: active
---

# apache-airflow-providers-vertica — Provider package apache-airflow-providers-vertica for Apache Airflow

License: permissive · Maintenance: active · Downloads: 228.0K/mo

## What it is and what it does

This is an Apache Airflow provider package that bridges Airflow workflows to Vertica databases. It supplies connection, hook, and operator abstractions so that Airflow DAG tasks can authenticate to Vertica instances, execute SQL queries, and manage data pipelines. The package depends on apache-airflow (>=2.11.0), vertica-python (>=1.3.0) for the actual database driver, and common Airflow provider utilities for SQL and compatibility layers.

It is designed for teams running Airflow orchestration who need Vertica as a data source or sink in their workflows. Installation is straightforward on top of an existing Airflow setup, and the package supports Python 3.10 through 3.14. An optional sqlalchemy extra is available for users who need ORM or advanced query construction.

Use it for:

- Schedule recurring SQL queries against Vertica and load results into downstream systems via Airflow DAGs.
- Build ETL pipelines that extract data from Vertica, transform it, and load into data lakes or warehouses.
- Monitor Vertica database health and performance by running diagnostic queries on a schedule within Airflow.
- Orchestrate multi-step data workflows where Vertica is one of several data sources or destinations.
- Automate data validation and reconciliation tasks that require direct Vertica database access from Airflow.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Integrates Vertica database connectivity into Apache Airflow, enabling DAG tasks to connect to, query, and manage Vertica instances.

Yes. This is a production-stable, actively maintained provider package with no known vulnerabilities, low install friction, and permissive licensing. Install it if you run Airflow and need to integrate Vertica databases into your orchestration workflows. Requires Apache Airflow >=2.11.0 and Python >=3.10.

## Install

pip install apache-airflow-providers-vertica
uv add apache-airflow-providers-vertica
poetry add apache-airflow-providers-vertica

## Installing apache-airflow-providers-vertica

Before you install: Low friction installation as a pure Python wheel. Actively maintained with recent releases; requires Apache Airflow >=2.11.0 and vertica-python >=1.3.0 as core dependencies.

License in practice: Licensed under Apache-2.0 (permissive), allowing use in commercial and open-source projects with minimal restrictions.

Quickstart:

pip install apache-airflow-providers-vertica

from airflow.providers.vertica.operators.vertica import VerticaOperator

task = VerticaOperator(
    task_id='query_vertica',
    sql='SELECT * FROM my_table',
    vertica_conn_id='vertica_default'
)

Requires an existing Apache Airflow installation (>=2.11.0) and a configured Vertica connection in Airflow's connection store.

Verify before relying:

- Specific Vertica database versions supported by vertica-python >=1.3.0
- Whether optional sqlalchemy dependency unlocks additional query or ORM features
- Exact Airflow operator and hook classes available in this provider

## Package facts

- License: Apache-2.0 (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 228.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

airflow vertica provider, airflow database integration, vertica connection airflow, airflow sql provider, vertica dag tasks, airflow data warehouse connector, airflow-provider, data-integration, workflow-orchestration

[View on SkillFed](https://skillfed.io/packages/apache-airflow-providers-vertica) · [View on PyPI](https://pypi.org/project/apache-airflow-providers-vertica/)