clickzetta-sql-syntax-guide

Document ClickZetta Lakehouse SQL syntax for DDL, DML, and DQL migrations.

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

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires , and includes references (resource) components.

What problem does it solve?

ClickZetta Lakehouse SQL syntax reference consolidates DDL, DML, and DQL across dialects to prevent migration pitfalls and to enable accurate porting of queries between Snowflake, Databricks, Spark SQL, and ClickZetta.

Core Features & Use Cases

  • Cross-dialect coverage: provides parity mapping and examples between Snowflake, Databricks, Spark SQL, and ClickZetta.
  • Migration guidance: offers practical guidance for migrating schemas, queries, and data pipelines with minimal friction.
  • Conversion rules & traps: documents explicit type conversions and common migration traps to avoid errors during porting.

Quick Start

Look up the target SQL syntax in the reference and port your Snowflake or Databricks queries to ClickZetta.

Frequently Asked Questions about clickzetta-sql-syntax-guide

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

FAQPage Schema
How do I migrate SQL queries from Snowflake to ClickZetta Lakehouse?

To migrate SQL queries from Snowflake to ClickZetta, reference cross-dialect parity mappings and practical fixes. This guide validates compatibility by documenting explicit type conversion rules and common migration traps to prevent porting errors.

What are the common SQL dialect differences between Databricks and ClickZetta?

Common SQL dialect differences between Databricks and ClickZetta involve DDL, DML, and DQL syntax variations. The reference provides comprehensive examples and explicit type conversion rules to navigate these cross-dialect differences accurately.

How do I convert Spark SQL scripts to ClickZetta syntax without errors?

To convert Spark SQL scripts to ClickZetta syntax without errors, apply the documented cross-dialect mappings and explicit type conversion rules. This approach helps validate compatibility and avoid common migration traps during porting.

Does the ClickZetta SQL reference cover DDL and DML operations for database migration?

Yes, the ClickZetta SQL reference covers DDL and DML operations for database migration. It consolidates syntax across Snowflake, Databricks, and Spark SQL to enable accurate porting of schemas, queries, and data pipelines.

What type conversion traps should I avoid when porting Databricks queries to ClickZetta?

When porting Databricks queries to ClickZetta, avoid type conversion traps by following the documented explicit conversion rules. The reference highlights common migration pitfalls and provides practical fixes to ensure query compatibility.