hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Shared reference library for the Informatica, Talend, and stored-procedure migration skills — do not invoke directly. Those skills link to it by name for the common migration steps — cloud detection and cost-aware materializations, dbt layer classification, best-practice tests/docs/contracts, data-parity validation…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Use when migrating a Coalesce (coalesce.io) project to a dbt project — the column-aware transformation platform for Snowflake/Databricks/BigQuery, exported as YAML via Git. Maps each node (Source/Stage/Persistent Stage/Dimension/Fact/View) to a dbt model, snapshot, or source; applies best-practice tests, docs, and…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Use when migrating an Informatica PowerCenter workflow or mapping (XML repository export) to a dbt project. Maps every transformation to a dbt model, snapshot, or macro; applies best-practice tests, docs, and contracts; validates the result against warehouse data; asks which cloud is in use to pick cost-aware…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Use when migrating Matillion pipelines/jobs to a dbt project — both Data Productivity Cloud pipelines (.orch.yaml / .tran.yaml) and Matillion ETL job exports (JSON). Maps each transformation component to a dbt model, snapshot, or macro; applies best-practice tests, docs, and contracts; validates the result against…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Use when migrating SQL stored procedures (Snowflake, BigQuery, Databricks, T-SQL/SQL Server, or Oracle PL/SQL) to a dbt project. Decomposes procedural logic (temp tables, MERGE, cursors, branching) into ref()-based dbt models, applies best-practice tests, docs, and contracts, proves row-for-row parity against the…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Use when migrating Talend ETL jobs (.item XML exports) to a dbt project. Maps every Talend component to a dbt model, snapshot, or macro; applies best-practice tests, docs, and contracts; validates the result against warehouse data; asks which cloud is in use to pick cost-aware materializations; and produces a…
hicham-bab/dbt-legacy-migration-skills
Skill Claude CodeCodex
Refactor an existing, poorly-migrated ("lift-and-shift") dbt project into idiomatic dbt without changing results. Use when a project already runs and returns correct numbers but is not maintainable: pre/post-hook overuse, monolithic models, hardcoded relations, retained control-flow, or missing staging/tests/docs.…