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

clickzetta-volume-manager

Mount and manage ClickZetta Lakehouse volumes for OSS/COS/S3 object storage.

8|3|Updated Mar 19, 2026
Search Tags:#s3#lakehouse#oss#object-storage#volume#volume-management#data-ingest
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-volume-manager
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickzetta-volume-manager
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-volume-manager
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-volume-manager

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Automates mounting and managing ClickZetta Lakehouse volumes to enable seamless access to object storage (OSS/COS/S3), efficient file discovery, and end-to-end data import/export workflows.

Core Features & Use Cases

  • External Volume creation and mounting using STORAGE CONNECTIONs for OSS/COS/S3.
  • Volume types including External, User, and Table volumes and their typical use cases.
  • Volume querying, directory listing, and metadata refresh to keep data discovery accurate.
  • Data import/export workflows via COPY INTO TABLE/VOLUME and SELECT FROM VOLUME across supported formats (CSV, Parquet, JSON, ORC, etc.).
  • User volume operations like PUT/GET/REMOVE for uploading, downloading, and managing user files.

Quick Start

Create an External Volume using a STORAGE CONNECTION, then mount it and run a simple query to verify access.

Frequently Asked Questions about clickzetta-volume-manager

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

FAQPage Schema
How do I mount an S3 bucket as an external volume for Lakehouse data ingest?▼

To mount S3, create an External Volume using a pre-configured STORAGE CONNECTION. This links the object storage to your Lakehouse, enabling seamless file querying and data import workflows.

What is the difference between external, user, and table volumes?▼

External volumes mount object storage like OSS or S3 for data ingest. User volumes manage individual files via PUT or GET operations, while table volumes support structured data import and export workflows.

Can I query CSV and Parquet files directly from a mounted OSS volume?▼

Yes, you can query CSV, Parquet, JSON, and ORC files directly from a mounted OSS volume. It supports SELECT FROM VOLUME operations to analyze data without prior ingestion into tables.

What's the best way to import and export data between Lakehouse tables and object storage?▼

Use COPY INTO TABLE or COPY INTO VOLUME operations to import and export data. This streamlines data movement across mounted external, user, and table volumes in formats like CSV and Parquet.

How do I keep directory listings and metadata accurate when querying S3 volumes?▼

Refresh DIRECTORY metadata regularly to keep file discovery accurate. This ensures volume querying and directory listing reflect the current state of files in your external object storage.

Do I need a STORAGE CONNECTION before creating an external volume for object storage?▼

Yes, a STORAGE CONNECTION is required before creating an external volume. It provides the necessary authentication to mount external object storage like OSS, COS, or S3 to your Lakehouse.

Related Skills

Explore More Data & Analytics Skills→
yunqiqiliangyunqiqiliang
8

clickzetta-oss-ingest-pipeline

Automate object storage ingestion pipelines into Lakehouse with COPY/INSERT and PIPE management.

Community
Advanced
yunqiqiliangyunqiqiliang
8

clickzetta-file-import-pipeline

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

Community
Advanced
nrminornrminor

duckdb

Query Parquet, CSV, and JSON files in place with DuckDB SQL.

Community
Intermediate
jezwebjezweb
961

cloudflare-r2

Store objects in Cloudflare R2 using the Workers API.

Community
Intermediate