Skip to main content

harlequin-odbc-vertica

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

Download files

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

Source Distributions

No source distribution files available for this release.See tutorial on generating distribution archives.

Built Distribution

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

harlequin_odbc_vertica-0.1.0-py3-none-any.whl (3.3 kB view details)

Uploaded Python 3

File details

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

File metadata

  • Download URL: harlequin_odbc_vertica-0.1.0-py3-none-any.whl
  • Upload date:
  • Size: 3.3 kB
  • Tags: Python 3
  • Uploaded using Trusted Publishing? No
  • Uploaded via: uv/0.12.6 {"installer":{"name":"uv","version":"0.12.6","subcommand":["publish"]},"python":null,"implementation":{"name":null,"version":null},"distro":{"name":"macOS","version":null,"id":null,"libc":null},"system":{"name":null,"release":null},"cpu":null,"openssl_version":null,"setuptools_version":null,"rustc_version":null,"ci":null}

File hashes

Hashes for harlequin_odbc_vertica-0.1.0-py3-none-any.whl
Algorithm Hash digest
SHA256 5f8691189966a632403669c44881f76ae26f270f3f35e9c565c1beb0ed67a519
MD5 147c35c8c4b3798a9cce4154a8c08b90
BLAKE2b-256 bdef1821bf1a78a156ea7cb1e929dbaa9b6e49262f6a6da25eb0f78230323596

See more details on using hashes here.

Release history Release notifications | RSS feed

0.1.1

2 files

This release

0.1.0 This release

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