clickzetta-bi-connect

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

8|3|Updated Mar 19, 2026
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-bi-connect
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: clickzetta-bi-connect
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-bi-connect
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-bi-connect

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Connect BI tools and database clients to ClickZetta Lakehouse with complete connection configurations, covering JDBC connections, SQLAlchemy URLs, and driver installation steps for the most popular tools.

Core Features & Use Cases

  • Provides ready-to-use connection templates for Apache Superset, Tableau, Metabase, DBeaver, DataGrip, and FineBI, among others.
  • Includes JDBC and SQLAlchemy connection strings and driver setup guidance to streamline BI onboarding.
  • Use Case: Data analysts can quickly connect their BI dashboards to Lakehouse to build reports without backend integration work.

Quick Start

Follow the references/bi-tools.md to configure your BI tool and establish a Lakehouse connection.

Frequently Asked Questions about clickzetta-bi-connect

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

FAQPage Schema
How do I connect BI tools to ClickZetta Lakehouse?

You can connect BI tools to ClickZetta Lakehouse using ready-to-use JDBC and SQLAlchemy configurations. The skill provides standard connection formats and driver installation guidance for clients like Tableau, Superset, and DataGrip.

What is the SQLAlchemy connection string for Apache Superset on ClickZetta Lakehouse?

The SQLAlchemy connection string for Apache Superset uses standard URL formats provided by the skill. It streamlines BI onboarding by including ready-to-use templates that ensure secure and consistent access to the Lakehouse.

Does Tableau support JDBC connections to ClickZetta Lakehouse?

Yes, Tableau supports JDBC connections to ClickZetta Lakehouse. The skill provides driver installation guidance and JDBC connection templates to ensure reliable setup and secure access across your environments.

Can I use DBeaver and DataGrip to query ClickZetta Lakehouse?

Yes, you can use DBeaver and DataGrip to query ClickZetta Lakehouse. The skill provides JDBC connection configurations and driver setup guidance for these database clients to establish reliable access.

Why does my Metabase connection to ClickZetta Lakehouse fail?

Metabase connections to ClickZetta Lakehouse may fail if driver setup is incomplete or the connection format is incorrect. The skill enforces standard JDBC and SQLAlchemy formats and provides driver installation steps to resolve setup issues.

Do I need to install a specific driver to connect FineBI to ClickZetta Lakehouse?

Yes, you need to install the correct driver to connect FineBI to ClickZetta Lakehouse. The skill includes driver installation guidance and ready-to-use connection templates to ensure a reliable setup without backend integration work.