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

clickzetta-data-recovery

Recover dropped or modified ClickZetta Lakehouse tables using Time Travel and UNDROP.

8|3|Updated Mar 19, 2026
Search Tags:#history#lakehouse#time-travel#data-retention#data-recovery#undrop#restore-table
One-click install
npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-data-recovery
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: clickzetta-data-recovery
Source: https://github.com/yunqiqiliang/clickzetta-skills/tree/main/clickzetta-data-recovery
Command: npx skills add https://github.com/yunqiqiliang/clickzetta-skills --skill clickzetta-data-recovery

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

ClickZetta Lakehouse 数据恢复与历史查询助手。覆盖 Time Travel 查询、UNDROP 恢复误删表、RESTORE TABLE 回滚到历史版本、DESC HISTORY 查看变更记录、SHOW TABLES HISTORY 查看删除记录、数据保留周期（data_retention_days）配置等完整数据恢复工作流。

当用户说"恢复误删的表"、"表被 DROP 了怎么办"、"回滚数据"、"查看历史版本"、 "时间旅行查询"、"UNDROP"、"RESTORE TABLE"、"数据保留周期"、"查看表的变更历史"、 "误操作 DELETE/UPDATE 怎么恢复"、"数据回滚"时触发。

包含 ClickZetta 特有的语法（TIMESTAMP AS OF、RESTORE TABLE TO、UNDROP TABLE） 以及数据保留周期默认值（默认 1 天，最长 90 天）等关键约束。

Core Features & Use Cases

  • Time Travel queries
  • UNDROP
  • RESTORE TABLE
  • DESC HISTORY / SHOW TABLES HISTORY
  • data_retention_days configuration

Quick Start

Initiate a data recovery workflow on a specified Lakehouse table using Time Travel and UNDROP.

Frequently Asked Questions about clickzetta-data-recovery

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

FAQPage Schema
How do I recover a dropped table in a Lakehouse?▼

To recover a dropped table in a Lakehouse, use the UNDROP TABLE command within your configured data retention period to safely restore the deleted table.

How can I roll back erroneous UPDATE or DELETE operations on my data?▼

Roll back erroneous UPDATE or DELETE operations by using RESTORE TABLE TO TIMESTAMP AS OF to revert your table data to a specific historical version.

What is time travel query and how does it work for historical data?▼

Time travel query uses TIMESTAMP AS OF syntax to view historical changes and query data as it existed at a specific past timestamp within the retention window.

How long are deleted tables retained for data recovery?▼

Deleted tables are retained for a default period of 1 day, with a maximum data retention period of 90 days configurable via ALTER TABLE SET PROPERTIES for data_retention_days.

Can I view the change history of a table before restoring it?▼

Yes, you can view the change history of a table before restoring it by using DESC HISTORY to inspect table change records and SHOW TABLES HISTORY to view deletion logs.

Does data recovery work after the data_retention_days limit expires?▼

Data recovery using UNDROP or RESTORE TABLE does not work after the data_retention_days limit expires, as historical versions and dropped tables are only retained up to a maximum of 90 days.

Related Skills

Explore More Data & Analytics Skills→
abdullah1854abdullah1854
1

fabric-helper

Generate Delta Lake and Spark SQL queries for Fabric Lakehouse and Warehouse.

Community
Intermediate
microsoftmicrosoft
952

spark-consumption-cli

Run interactive PySpark and Spark SQL queries on Fabric Lakehouse Livy sessions.

Official
Advanced
developer-advocacy-dremiodeveloper-advocacy-dremio

Dremio Iceberg Operations

Manage Iceberg tables with ACID DML operations in Dremio.

Official
Advanced
jeremylongshorejeremylongshore
2.6k

fairdb-backup-manager

Automate FairDB PostgreSQL backup and recovery with pgBackRest and Wasabi S3.

Community
Advanced