Convert raw source tables into standardized dbt staging models with 1:1 mapping.
npx skills add https://github.com/nrakow/ae-skills-dev --skill staging-layer
Please help me install this Agent Skill. Skill: staging-layer Source: https://github.com/nrakow/ae-skills-dev/tree/main/skills/staging-layer Command: npx skills add https://github.com/nrakow/ae-skills-dev --skill staging-layer
Build dbt staging models that convert raw source data into a clean, consistent staging layer with a 1:1 mapping.
Create a new staging model by inspecting the raw source with schema-introspect.js and naming it using stg_<source_name>__<table_name>, then run dbt compile and dbt test --select staging to validate.
High-intent search queries and answers about installing and using this skill.
To standardize raw data into dbt staging models, use schema introspection to inspect source tables and apply strict renaming and casting rules to generate stg_<source_name>__<table_name> SQL files with 1:1 source mapping.
The correct dbt staging model naming convention is stg_<source_name>__<table_name>, ensuring a strict 1:1 mapping from each raw source table to its corresponding staging model without joins or business logic.
Yes, schema introspection reads existing raw source columns to generate sources.yml and schema.yml outputs. This avoids duplicate source definitions and ensures column stability during dbt staging layer creation.
Validate dbt staging models after onboarding new data sources by running dbt compile to check SQL generation and dbt test --select staging to enforce data quality and transformation rules on the staging layer.
No, you should not add joins or business logic in dbt staging models. The staging layer enforces a strict 1:1 source-to-staging mapping to reduce downstream transformation errors by only applying renaming and casting.
Yes, the staging layer approach works for auditing existing transformations by using schema introspection to verify column stability and strict renaming rules against current stg_<source_name>__<table_name> models and sources.yml definitions.
Stream-claimsQuery Redshift staging and raw tables, debug dbt models, and troubleshoot ETL pipelines.
Sumeet138Organize dbt analytics projects with pattern-based structures for sources, staging, intermediate, and marts.
AI-Foundry-CoreAutomate dbt analytics transformations with staging, intermediate, and marts model layers.
AltimateAIConvert SQL stored procedures, views, and raw SQL files into dbt models.
