apache-airflow-providers-vertica

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 on this page — 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

apache-airflow-providers-vertica on PyPI

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

Evidence: apache_airflow_providers_vertica-4.4.0-py3-none-any.whl

Keywords: airflow-provider, vertica, airflow, integration

Tags

More Monitoring packages