harlequin-odbc-vertica

PyPI CI

A Harlequin adapter for Vertica via ODBC.

This adapter extends harlequin-odbc to fix Vertica-specific issues with catalog and column metadata retrieval.

Problem

The standard harlequin-odbc adapter has two issues when used with Vertica:

  1. Empty Data Catalog: Vertica's ODBC driver returns None for catalog names, causing all tables to be filtered out.
  2. Column listing error: Vertica's ODBC driver does not support the catalog parameter in SQLColumns, resulting in HYC00 errors.

Solution

harlequin-odbc-vertica overrides two methods in the ODBC adapter:

  • _list_tables: Uses SELECT current_database() as a fallback when the catalog name is None.
  • _list_columns_in_relation: Omits the catalog parameter when calling pyodbc.Cursor.columns().

Installation

pip install harlequin-odbc-vertica

Or with uv:

uv tool install harlequin --with harlequin-odbc-vertica

Prerequisites

You need:

Usage

harlequin -a odbc-vertica 'DRIVER={Vertica};SERVER=your-server;PORT=5433;DATABASE=your-db;UID=user;PWD=password'

License

MIT

Project links

Data verified by PyPI on Aug 31, 2026
Data provided by the project maintainers, verified at the time the release was uploaded to PyPI.

Key dates

PyPI data
Data sourced directly from PyPI's database.
  • Released:
Latest release

1 maintainer

PyPI data
Data sourced directly from PyPI's database.
Avatar for clang.engineer from gravatar.com clang.engineer

Credits

Author: clang-engineer

GitHub Statistics

Data verified by PyPI on Aug 31, 2026
The GitHub source repository was provided by the project maintainers and verified by PyPI at the time of upload. Stars, forks, and open issues/PRs are derived from that repository and have not been independently verified.

License expression

MIT
View SPDX License List

Requires

Python >=3.10

Tags

database harlequin odbc sql vertica

Classifiers

Report project as malware

Download files

Download the file for your platform. If you're not sure which to choose, learn more about installing packages.

Source Distribution

harlequin_odbc_vertica-0.1.1.tar.gz (3.6 kB view details)

Uploaded Source

Built Distribution

If you're not sure about the file name format, learn more about wheel file names.

harlequin_odbc_vertica-0.1.1-py3-none-any.whl (4.3 kB view details)

Uploaded Python 3

File details

Details for the file harlequin_odbc_vertica-0.1.1.tar.gz.

File metadata

  • Download URL: harlequin_odbc_vertica-0.1.1.tar.gz
  • Upload date:
  • Size: 3.6 kB
  • Tags: Source
  • Uploaded using Trusted Publishing? Yes
  • Uploaded via: twine/7.0.0 CPython/3.13.14

File hashes

Hashes for harlequin_odbc_vertica-0.1.1.tar.gz
Algorithm Hash digest
SHA256 6b55aecfa0e99ef4ba63ae2c359b894b76af642962e8474d0b3bd0e02853db50
MD5 21d39dc5a2b7bc890341653c403e730f
BLAKE2b-256 4e15e6e661292d330fca54909ddc214c7fb84e98d032cd06ecc0737a45e3626f

See more details on using hashes here.

Provenance

The following attestation bundles were made for harlequin_odbc_vertica-0.1.1.tar.gz:

Publisher: publish.yml on clang-engineer/harlequin-odbc-vertica

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

File details

Details for the file harlequin_odbc_vertica-0.1.1-py3-none-any.whl.

File metadata

File hashes

Hashes for harlequin_odbc_vertica-0.1.1-py3-none-any.whl
Algorithm Hash digest
SHA256 5e7d1e25b4ace0096a9ec4fb43598761d9cad60107bec6fffcb38cd21aaf6492
MD5 9b9014445a9e1cd41695a5066807489c
BLAKE2b-256 123683de3548d0cd1b0e35880041ead960fc598ced024e355a897fd8b4614637

See more details on using hashes here.

Provenance

The following attestation bundles were made for harlequin_odbc_vertica-0.1.1-py3-none-any.whl:

Publisher: publish.yml on clang-engineer/harlequin-odbc-vertica

Attestations: Values shown here reflect the state when the release was signed and may no longer be current.

Release history Release notifications | RSS feed

This release

0.1.1 This release

2 files

0.1.0

1 file

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page