delta-lake-and-medallion-architecture

delta-lake-and-medallion-architecture is a skill for Claude Code, Codex from vaquarkhan/data-engineering-agent-skills. It costs 59 tokens per session (568 once invoked), scanned A, original, MIT.

Guidance for organizing a Delta Lake, a table system for data lakes, into bronze, silver, and gold layers. Bronze keeps incoming data, silver cleans and standardizes it, and gold contains trusted outputs for users or applications.

In plain words
What is it for?
Use it when designing or changing Delta Lake tables, Databricks batch or streaming pipelines, layer responsibilities, or data-merging rules.
Why use it?
It provides clear rules for how data changes as it moves through the lakehouse, including updates, deletes, and change capture. This reduces confusion about which data is raw, trusted, or ready to publish.

Skill for Claude CodeCodex

Written for no agent in particular: nothing here depends on one.

Good fit Use it when designing or changing Delta Lake tables, Databricks batch or streaming pipelines, layer responsibilities, or data-merging rules.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture
Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add vaquarkhan/data-engineering-agent-skills --skill delta-lake-and-medallion-architecture
Clone the repo
git clone --depth 1 https://github.com/vaquarkhan/data-engineering-agent-skills

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for delta-lake-and-medallion-architecture

README.md
[![agentmods](https://agentmods.dev/badge/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture/github.svg)](https://agentmods.dev/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture)
Your own site
<a href="https://agentmods.dev/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture"><img src="https://agentmods.dev/badge/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for delta-lake-and-medallion-architecture

Your own site · 80×15
<a href="https://agentmods.dev/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture"><img src="https://agentmods.dev/badge/skills/vaquarkhan/data-engineering-agent-skills/delta-lake-and-medallion-architecture.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 59 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 568 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe.
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00059 $0.00568
Opus 5 $0.00030 $0.00284
Sonnet 5 $0.00012 $0.00114
Haiku 4.5 $0.00006 $0.00057

Measured 12d ago against content hash 853a8d782556, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-12, from the pricing page.

Security

Grade A, and why

delta-lake-and-medallion-architecture scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 12d ago.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/delta-lake-and-medallion-architecture/SKILL.md · 70 lines

How it starts

The opening of the file, as written. The whole thing — 70 lines — stays where its author put it; the contents beside it link to each section on GitHub.

Delta Lake And Medallion Architecture

Overview

Use this skill when a Delta Lake-based lakehouse needs more than generic table-format guidance. It helps agents design medallion-style layers, transactional update behavior, CDC merges, and publish-safe transformation paths for Delta-centric platforms.

When to Use

  • designing bronze, silver, and gold layering
  • implementing Delta Lake merges, upserts, or deletes
  • building Databricks-centered batch and streaming lakehouse flows
  • deciding how raw landing data evolves into trusted publish outputs

Do not use medallion terminology as decoration if the layers do not carry distinct responsibilities.

Workflow

  1. Define the layer responsibilities. Typical pattern:

    • bronze: raw or lightly standardized landing
    • silver: cleaned, conformed, contract-aware transformations
    • gold: business-facing publish-ready outputs
  2. Define movement rules between layers. Capture:

    • validation requirements
    • mutation behavior
    • CDC merge strategy
    • schema enforcement and evolution policy
  3. Keep bronze permissive and gold disciplined. Raw survival and publish trust need different operating rules.

  4. Coordinate batch and streaming writers carefully. Checkpoints, merges, and small-file behavior must support recovery and maintenance.

  5. Plan maintenance as part of the architecture. Include:

    • compaction
    • retention
    • optimization
    • cleanup

Common Rationalizations

Rationalization Reality
"Bronze, silver, and gold are enough architecture by themselves." Layer names without contracts and rules create confusion, not design clarity.
"We can merge everything directly into gold." Business-facing layers need stronger validation and stability than raw ingestion paths.
"Delta transactions solve every operational problem." You still need thoughtful layering, maintenance, and replay design.

Red Flags

  • bronze, silver, and gold have no explicit responsibilities
  • gold tables are fed directly from unstable raw landing logic
  • merge semantics are unclear for CDC or late data
  • maintenance tasks such as compaction are ignored

Read the full file on GitHub · 70 lines

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 12d ago First seen · 70 lines · 59 tokens per session scan A 853a8d782556

Subscribe to this mod's changes

delta-lake-and-medallion-architecture is a skill published in the GitHub repository vaquarkhan/data-engineering-agent-skills (45 stars, last pushed 3mo ago), licensed MIT. It adds 59 tokens to every session and 568 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-08-30.

Related

Other skills, from other repositories

kafka-shadowtraffic

Generate a ShadowTraffic configuration to populate a Kafka topic with realistic synthetic data. Discovers the target topic, its key and value schemas, and the correct serializers from the live cluster via any attached Kafka MCP server, then writes a ready-to-run shadowtraffic-config.json and Docker command. Use when…

lensesio/agentic-engineering-for-apache-kafka · 134 tokens

spark-training-gotchas

Preflight and diagnose the ten known failure modes for ML training on NVIDIA DGX Spark. Use when a training run on DGX Spark fails to start, OOMs below the 128GB limit, slows down mid-run, or before any multi-hour training job on GB10.

wshobson/agents · 63 tokens

9router

Entry point for 9Router — local/remote AI gateway with OpenAI-compatible REST for chat, image, TTS, embeddings, web search, web fetch. Use when the user mentions 9Router, NINEROUTERURL, or wants AI without writing provider boilerplate. This skill covers setup + indexes capability skills; fetch the relevant capability…

decolua/9router · 84 tokens

aeon

This skill should be used for time series machine learning tasks including classification, regression, clustering, forecasting, anomaly detection, segmentation, and similarity search. Use when working with temporal data, sequential patterns, or time-indexed observations requiring specialized algorithms beyond standard…

synthetic-sciences/openscience · 74 tokens

lookml_ingest

Map a LookML view/model/explore into ktx semantic layer sources. Covers the LookML to ktx primitive table, provenance tagging, and three worked examples (overlay, standalone from derivedtable, standalone with sqlalwayswhere). Load when the turn contains .lkml content.

Kaelio/ktx · 63 tokens

markitdown

Convert files and office documents to Markdown. Supports PDF, DOCX, PPTX, XLSX, images (with OCR), audio (with transcription), HTML, CSV, JSON, XML, ZIP, YouTube URLs, EPubs and more.

synthetic-sciences/openscience · 53 tokens