Registry / database / clickzetta-connector-python

clickzetta-connector-python

library0.8.109pypypi✓ verified 85d ago

Official Python connector for ClickZetta cloud database. Version 0.8.109. Provides a DB-API 2.0 interface for querying and managing ClickZetta clusters. Regular releases.

database aws

pip install clickzetta-connector-python

package ↗homepage ↗docs ↗

INSTALL

IMPORT

SIG · CLICKZETTA-CONNECT

clickzetta-connector-python

databasepythonv0.8.109

Install

12.2s avg

Import

2493ms

Disk

364MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.8.109 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 2.562s · 372.4MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 12.2s · import 2.424s · 338MB

364MB installed

● package 364MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

clickzetta

✓ import clickzetta

✗ from clickzetta_connector import clickzetta

Direct import of clickzetta package is correct; don't use underscore variant.

connect

✓ from clickzetta import connect

✗ from clickzetta_connector import connect

connect function is in the top-level clickzetta module.

Establishes a WebSocket connection to ClickZetta, executes a query, and prints the result.

import clickzetta conn = clickzetta.connect( url=os.environ.get('CLICKZETTA_URL', 'ws://localhost:8080/ws'), user=os.environ.get('CLICKZETTA_USER', 'default'), password=os.environ.get('CLICKZETTA_PASSWORD', ''), database='default' ) cursor = conn.cursor() cursor.execute('SELECT version()') print(cursor.fetchone()) cursor.close() conn.close()

Debug

Known issues

breakingIn version 0.8.x, the WebSocket endpoint changed from '/sql' to '/ws'. Old clients using '/sql' will get connection errors.

fix

Update the URL to use '/ws' (default: ws://host:port/ws).

affects: >=0.7, <0.8.0

deprecatedThe 'database' parameter in connect() is deprecated; use 'schema' instead.

fix

Use conn.set_schema('schema_name') or include schema in SQL.

affects: >=0.8.0

gotchaThe connector uses WebSocket, not HTTP. Ensure your firewall allows WebSocket traffic on the configured port.

fix

Use ws:// or wss:// URL and verify network connectivity.

affects: all

Errors

Common errors & fixes

clickzetta.exceptions.ClickZettaError: 401 Unauthorized

Invalid username or password provided in connect().

fix

Double-check credentials; ensure user exists and password is correct. Use environment variables.

websockets.exceptions.InvalidHandshake: Status 403

Server IP is not allowed or WebSocket subprotocol mismatch.

fix

Check firewall rules and ensure ClickZetta server allows WebSocket connections from your IP.

AttributeError: module 'clickzetta' has no attribute 'connect'

Importing from 'clickzetta_connector' instead of 'clickzetta'.

fix

Use 'import clickzetta' or 'from clickzetta import connect'.

Upgrade

Version history

0.8.109latest on PyPI · released Dec 24, 2025

Audit

Dependencies

requestsrequiredHTTP requests to ClickZetta API

pandasoptionalOptional: for DataFrame conversion

Agent activity

24 hits · last 30 days

node

OpenAI (training)

Resources

packagehttps://pypi.org/project/clickzetta-connector-python/ ↗

homepagehttps://clickzetta.com ↗

docshttps://www.yunqi.tech/ ↗