clickzetta-lakehouse-connect

Name: clickzetta-lakehouse-connect
Availability: InStock
Author: qiliang

Connect to ClickZetta Lakehouse using Python SDK, ZettaPark, SQLAlchemy, and JDBC.

8|3|Updated Mar 19, 2026

Search Tags:#sdk #sqlalchemy #lakehouse #connect #zettapark #clickzetta

Ready to run

npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-lakehouse-connect

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: clickzetta-lakehouse-connect
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-lakehouse-connect
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-lakehouse-connect

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill provides a unified, end-to-end guide to connect to ClickZetta Lakehouse using Python SDK, ZettaPark, SQLAlchemy, and JDBC, enabling developers to initialize working connections and perform queries without hunting through disparate docs.

Core Features & Use Cases

Python SDK: use clickzetta.connect() to establish a connection and execute SQL
ZettaPark Session: leverage DataFrame API for ETL-style transformations
SQLAlchemy / JDBC: enable ORM or JDBC-based BI integrations
Use Case: connect to a Lakehouse instance, list schemas and tables, and run example queries across different clients

Quick Start

Use the Lakehouse connect guide to connect with Python SDK, ZettaPark, SQLAlchemy, or JDBC and run a basic query.

Frequently Asked Questions about clickzetta-lakehouse-connect

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I connect to ClickZetta Lakehouse using Python SDK?▼

To connect to ClickZetta Lakehouse using Python SDK, use the clickzetta.connect() method with required parameters like service, instance, workspace, schema, username, password, and vcluster to establish a session and execute SQL queries directly.

Can I use SQLAlchemy to query schemas and list tables in ClickZetta Lakehouse?▼

Yes, you can use SQLAlchemy to connect to ClickZetta Lakehouse for ORM-based integrations. This enables you to query schemas, list tables, and perform data engineering tasks seamlessly within your Python environment.

What connection parameters are required to access ClickZetta Lakehouse?▼

Accessing ClickZetta Lakehouse requires essential connection parameters: service, instance, workspace, schema, username, password, and vcluster. These parameters are necessary across all supported clients including Python SDK, ZettaPark, SQLAlchemy, and JDBC.

Does ClickZetta Lakehouse support JDBC-based BI integrations?▼

Yes, ClickZetta Lakehouse supports JDBC-based BI integrations. This allows you to connect from Java environments and various BI tools to query schemas, list tables, and perform data engineering tasks using standard JDBC drivers.

What is the best way to perform ETL transformations in ClickZetta Lakehouse?▼

The best way to perform ETL transformations in ClickZetta Lakehouse is using the ZettaPark Session and its DataFrame API. This approach allows you to execute ETL-style transformations efficiently after establishing your connection.