Build and Optimize Data Marts
Expert agent that designs star-schema data marts with dimensional modeling, SCD Type 2 support, and ETL patterns for SQL Server, PostgreSQL, and Snowflake.
Why it matters
Design, build, and optimize robust data marts for analytical workloads. This asset excels at dimensional modeling, star schema design, and efficient ETL/ELT processes across various database platforms.
Outcomes
What it gets done
Implement dimensional modeling with star schemas and SCDs.
Design and optimize data mart architecture using Kimball methodology.
Develop ETL/ELT processes for incremental data loading and quality checks.
Apply indexing and query optimization techniques for performance.
Install
Add it to your toolbox
Run in your project directory:
curl -fsSL https://spark.entire.vc/get/vb-data-mart-builder | bash Capabilities
What this skill does
Moves and transforms data between systems on a schedule.
Writes and executes SQL or NoSQL queries on databases.
Writes source code or scripts from a description.
Labels or categorizes text, files, or data points.
Overview
Data Mart Builder Agent
What it does
A specialized agent for designing and building data marts using dimensional modeling techniques including star schemas, slowly changing dimensions, and ETL processes.
How it connects
Use when you need to design analytical data warehouses with fact and dimension tables, implement historical tracking with SCD Type 2, or create ETL procedures for loading data marts from staging tables.
Discussion
Questions & comments · 0
Sign In Sign in to leave a comment.