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

clickzetta-monitoring

Monitor ClickZetta Lakehouse job status and performance via SHOW JOBS and information_schema views.

8|3|Updated Mar 19, 2026
Search Tags:#monitoring#metadata#lakehouse#information_schema#show jobs#job_history#query_performance
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-monitoring
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickzetta-monitoring
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-monitoring
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-monitoring

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

Monitor and analyze ClickZetta Lakehouse jobs to track status, performance, and resource usage, and to query metadata via INFORMATION_SCHEMA for governance and troubleshooting.

Core Features & Use Cases

  • Real-time visibility of jobs with SHOW JOBS across VClusters and statuses.
  • Historical analysis of job runs via sys.information_schema.job_history and related views.
  • Performance insights including slow queries, execution times, and cluster load.
  • Metadata discovery and governance queries across information_schema (schemas, tables, columns, workspaces).
  • Use Case: Identify failing jobs, optimize runtimes, and inventory workloads across environments.

Quick Start

Ask to show the current jobs and the past week's job history for your default VCluster.

Frequently Asked Questions about clickzetta-monitoring

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

FAQPage Schema
How do I monitor ClickZetta Lakehouse jobs in real-time?▼

You can monitor ClickZetta Lakehouse jobs in real-time by executing the SHOW JOBS SQL command, which provides live visibility into operational statuses and workloads across virtual clusters.

How do I check the history of failed jobs in a Lakehouse using information_schema?▼

Query the sys.information_schema.job_history view to retrieve historical job run records, allowing you to identify failed jobs, analyze execution times, and troubleshoot workload issues.

Can I analyze query performance and slow queries across virtual clusters?▼

Yes, you can analyze query performance and identify slow queries by querying information_schema views and job history, which exposes execution times and cluster load metrics for diagnostics.

What is the best way to discover metadata for governance in a Lakehouse?▼

The best way to discover metadata for governance is by querying information_schema views to inventory schemas, tables, columns, and workspaces across your Lakehouse environments.

Does this job monitoring approach require any external dependencies?▼

No, this job monitoring approach requires no external dependencies, relying entirely on native SQL queries like SHOW JOBS and information_schema views within the ClickZetta environment.

Related Skills

Explore More Data & Analytics Skills→
yunqiqiliangyunqiqiliang
8

clickzetta-manage-comments

Manage ClickZetta Lakehouse object comments across schemas, tables, and views.

Community
Intermediate
VictoriaMetricsVictoriaMetrics
45

victoriametrics-unused-metrics-analysis

Identify unused VictoriaMetrics metrics via the metric_names_stats API and propose drop or relabeling actions.

Official
Advanced
ivanshamaevivanshamaev
14

infra-gcp-data-platform-review

Review GCP data platform designs for BigQuery security and cost risks.

Community
Advanced
djankiesdjankies

preventing-sql-injection

Enforce parameterized Prisma raw SQL with $queryRaw tagged templates.

Community
Advanced