retail-etl-medallion-pipeline
Turn retail records into analytics-ready tables.
What it does
Builds a layered retail data pipeline that turns sales, inventory, and supplier records into analytics-ready tables.
When to use it
Use when building a retail data warehouse or transforming retail sales and inventory through Bronze, Silver, and Gold layers.
How to use it
Give it retail CSV exports and a pipeline-building request; it provides an implementation with ingestion, transformation, analytics tables, and validation.
What you provide
- Your files
Uses
Good to know
- cannot be undone: SQL Server
What you need · 4
Requires a SQL Server instance; the existing-instance setup specifies version 2017 or later.
Uses sqlcmd to connect to SQL Server and initialize the database from SQL scripts.
Access · 2
This skill
SQL Server
Replaces retail warehouse table contents (irreversible)
/logs/products_errors.txt
Writes product import errors