Design dimensional models and generate DDL with surrogate keys.
npx skills add https://github.com/mahg-es/araya --skill data-modeling-mahg-es
Please help me install this Agent Skill. Skill: data-modeling Source: https://github.com/mahg-es/araya/tree/main/skills/data-modeling Command: npx skills add https://github.com/mahg-es/araya --skill data-modeling-mahg-es
Design data models — conceptual, logical, and physical — using star schemas, dimensional modeling, slowly changing dimensions, and Data Vault patterns for analytics, reporting, and AI/ML readiness.
Define the business processes and grain, then create dimensions and facts to implement a star-schema data model.
High-intent search queries and answers about installing and using this skill.
Designing a star schema for a data warehouse involves defining the business process, establishing the grain, and creating fact and dimension tables to support analytics and reporting.
Use SCD Type 2 in dimensional modeling when you need to preserve historical attribute changes over time, whereas Type 1 overwrites data and Type 3 tracks limited historical changes.
The best way to generate DDL with surrogate keys is to apply dimensional modeling patterns that define explicit grain and star-schema integrity, producing implementation-ready DDL.
Yes, you can apply Data Vault patterns on a lakehouse to design scalable physical data models that support analytics, reporting, and AI/ML readiness alongside SCD strategies.
Yes, dimensional modeling works for BI-ready datasets and transactional processing by creating logical and physical models with explicit grain, surrogate keys, and fact tables.
Defining an explicit grain in dimensional modeling matters because it establishes the precise level of detail for each fact table record, ensuring star-schema integrity and accurate analytics.
cornmanwtfDesign star and snowflake schemas with fact tables and dimensions.
nrakowDesign dimensional data models and warehouse schemas for analytics projects.
microsoftExecute authoring SQL against Microsoft Fabric Data Warehouse endpoints via CLI.
hyukudanProvides guidance on data modeling patterns for OLTP and OLAP systems.
