skills.rest
yunqiqiliang
yunqiqiliangCOMMUNITY
Explore all skills by this author →
GitHub

clickzetta-lakehouse-connect

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
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-lakehouse-connect
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
FabianrzsFabianrzs

prisma-database-setup

Configure Prisma across PostgreSQL, MySQL, SQLite, MongoDB, and SQL Server.

Community
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-zettapark

Orchestrate Lakehouse data workflows with a Python DataFrame API.

Community
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-bi-connect

Configure JDBC and SQLAlchemy connections for BI tools to ClickZetta Lakehouse.

Community
Intermediate
felixboehmfelixboehm

reactome-database

Query the Reactome REST API for pathway enrichment and expression analysis.

Community
Intermediate