skills.rest
sfc-gh-samaurer
sfc-gh-samaurerCOMMUNITY
Explore all skills by this author →
GitHub

ingestion-to-consumption-mapper

Generate data lineage diagrams and Excel reports for Snowflake Medallion Architecture pipelines.

1|Updated Apr 8, 2026
Search Tags:#ETL#Snowflake#Excel#data lineage#data architecture
One-click install
npx skills add https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files --skill ingestion-to-consumption-mapper
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: ingestion-to-consumption-mapper
Source: https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files/tree/main/skills/ingestion-to-consumption-mapper
Command: npx skills add https://github.com/sfc-gh-samaurer/Sam-Maurer-s-SnowWork-Skills-and-Files --skill ingestion-to-consumption-mapper

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill helps Data Engineers and analysts create comprehensive maps of data flow from source systems through different processing layers, ensuring traceability and compliance.

Core Features & Use Cases

  • Data Lineage Mapping: Generate detailed Excel reports illustrating source-to-raw, curated, and consumption data pathways.
  • Layer Design Support: Assist in planning or documenting Bronze, Silver, and Gold layers within Snowflake architectures.
  • Use Case: Use in medallion architecture projects to verify data flow and identify bottlenecks or data quality issues.

Quick Start

Ask it to generate a complete data lineage map for your existing data pipeline, including source systems, transformation layers, and reporting domains.

Frequently Asked Questions about ingestion-to-consumption-mapper

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

FAQPage Schema
How do I create a data lineage map for a Snowflake medallion architecture?▼

You can create a data lineage map for a Snowflake medallion architecture by using this Skill to automatically generate detailed Excel reports and diagrams illustrating source-to-raw, curated, and consumption data pathways.

What is the best way to document data flow from source ingestion to reporting domains?▼

Documenting data flow from source ingestion to reporting domains is best handled by generating automated Excel reports that map transformations across your processing layers, ensuring traceability and compliance.

Can I visualize Bronze, Silver, and Gold layer data pathways in Excel?▼

Yes, you can visualize Bronze, Silver, and Gold layer data pathways in Excel. This Skill uses Python scripting with openpyxl to automate the generation of detailed data lineage visualizations for Snowflake architectures.

How do I identify data quality bottlenecks across my ETL pipeline layers?▼

To identify data quality bottlenecks across your ETL pipeline layers, generate a comprehensive data lineage map to verify data flow and inspect transformation steps from source ingestion through to reporting domains.

Does this data lineage mapping tool require external dependencies to generate reports?▼

No external dependencies are required. This Skill employs internal Python scripting with openpyxl to automate report generation and visualization, operating independently to construct detailed data lineage diagrams.

Related Skills

Explore More Data & Analytics Skills→
Snowflake-LabsSnowflake-Labs
1

unit-test-migrator-setup

Configure Snowflake connections and deploy validation schemas for migration projects.

Official
Intermediate
CatsofsufferingCatsofsuffering
5

data-engineering

Manage and validate data pipelines and streaming workflows across orchestration and quality tools.

Community
Advanced
erichowenserichowens
181

data-pipeline-engineer

Automate ETL/ELT pipeline design, validation, and operation across medallion architectures.

Community
Advanced
WdanielBWdanielB

algorithmic-art

Generate interactive p5.js sketches from a computational philosophy.

Community
Advanced