Skills
.Work. You
Rest

etl-dwd-to-dws

Official

Trigger DWD to DWS ETL pipeline

Data & Analytics#metrics#pipeline#data processing#etl#dwd#dws
AuthorMJ-AgentLab
Version1.0.0
Installs0

System Documentation

What problem does it solve?

This skill bypasses the standard 5-minute polling wait for the QCM ETL pipeline, allowing for immediate updates to DWS metrics after DWD data is ready, or when DWS tables are empty or metrics are stale.

Core Features & Use Cases

  • Immediate ETL Triggering: Manually initiate the QCM ETL process to bypass scheduled waits.
  • DWS Metric Updates: Ensure DWS metrics are current when DWD data is updated.
  • Troubleshooting Stale Data: Resolve issues where DWS tables appear empty or metrics haven't refreshed.
  • Use Case: After a significant update to DWD data, you need to see the reflected DWS metrics immediately for a business review. Instead of waiting up to 10 minutes, you use this skill to trigger the ETL pipeline instantly.

Quick Start

Manually trigger the QCM ETL pipeline by running the command docker exec mj-system-postgres psql -U admin -d mj_system_db -c "SELECT * FROM biz_dws.run_qcm_etl_if_ready(0);".

Dependency Matrix

Required Modules

None required

Components

scriptsreferences

💻 Claude Code Installation

Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.

Please help me install this Skill:
Name: etl-dwd-to-dws
Download link: https://github.com/MJ-AgentLab/mj-agentlab-marketplace/archive/main.zip#etl-dwd-to-dws

Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
View Source Repository

Agent Skills Search Helper

Install a tiny helper to your Agent, search and equip skill from 223,000+ vetted skills library on demand.