Skill: Advanced Iceberg & WAP (Write-Audit-Publish)

Description

Enables the agent to model, implement, and orchestrate the Write-Audit-Publish (WAP) pattern natively using Apache Iceberg branches.

Context

In an Enterprise data lakehouse, writing directly to production tables (main branch) during ETL processes poses a massive risk of data corruption. Apache Iceberg solves this natively with Git-like branching. The agent must implement WAP patterns over traditional staging tables.

Instructions

1. WAP Pattern Flow

Instead of creating _stg tables, instruct the user to use Iceberg branches.

Step 1: Create a Branch Create a branch pointing to the current state of main.

ALTER TABLE prod.sales.transactions CREATE BRANCH etl_job_123;