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

clickzetta-file-import-pipeline

Import data from URLs, local files, or volumes into ClickZetta tables.

8|3|Updated Mar 19, 2026
Search Tags:#pipeline#import#data-validation#format-detection#volume#data-ingest#copy-into
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-file-import-pipeline
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickzetta-file-import-pipeline
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-file-import-pipeline
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-file-import-pipeline

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill enables end-to-end data import into ClickZetta tables from a URL, local file, or Volume path, handling file retrieval, format inference, table creation or updating, COPY INTO import, and result validation.

Core Features & Use Cases

  • Source flexibility: import data from HTTP URLs, local files, or Volume paths with automatic handling.
  • Format inference: detect CSV/JSON/Parquet/ORC formats and apply appropriate COPY INTO options.
  • Table write modes: support create (new table), append (existing table), and overwrite (truncate before load).
  • In-place validation: verify import results with row counts and sample data.

Quick Start

Set the data source (URL, local file, or Volume path) and run a single import to create or update the target table and validate results.

Frequently Asked Questions about clickzetta-file-import-pipeline

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

FAQPage Schema
How do I import data into ClickZetta tables from an external URL or local file?▼

To import data into ClickZetta, you can use the COPY INTO ingestion method which handles source retrieval from URLs, local files, or Volume paths, automatically infers the file format, and creates or updates the target table.

What is the best way to ingest CSV or Parquet files into ClickZetta without manual schema definition?▼

The best way to ingest CSV or Parquet files into ClickZetta is using automatic format inference, which detects file schemas and applies appropriate COPY INTO options to create the target table dynamically before loading the data.

Can I append or overwrite existing ClickZetta tables when loading data from a Volume path?▼

Yes, you can append or overwrite existing ClickZetta tables when loading data from a Volume path by selecting the appropriate write mode, which supports appending to existing tables or truncating before loading new data.

How does data validation work after completing a COPY INTO data import in ClickZetta?▼

Data validation after a COPY INTO import in ClickZetta works by performing in-place checks, verifying the final row counts and retrieving sample data from the target table to ensure reliable ingestion and consistency.

Does ClickZetta data ingestion support diverse formats like JSON and ORC for end-to-end table loading?▼

Yes, ClickZetta data ingestion supports diverse formats like JSON and ORC for end-to-end table loading, handling format inference and applying the correct COPY INTO options automatically for reliable data ingestion.

Related Skills

Explore More Data & Analytics Skills→
starlake-aistarlake-ai
209

kafkaload

Transfer data between Kafka topics and file storage in Parquet, JSON, and CSV formats.

Official
Intermediate
akillnessakillness
40

data-analysis

Analyze CSV, JSON, and SQL datasets with Python pandas workflows.

Community
Intermediate
leonardoteodorooleonardoteodoroo

ml-pipeline-workflow

Automate end-to-end ML pipeline orchestration from data preparation to deployment.

Community
Advanced
starrank-softstarrank-soft

data-throughput-accelerator

Accelerate large-scale data ingestion with idempotent writes and manifest-based tracking.

Official
Advanced