Transform

Author and refactor the dbt project, both the SQL (staging to marts, tests, docs) and the semantic layer on top. You write the file content; the engine validates it, computes the diffs, and stores a plan. Nothing reaches the project until transform apply, and any build runs against a dev target only.

Procedure

Dex works in one loop: explore, transform, maintain. dex <command> below is the dex CLI; where it is not installed, run the same command through the skill's scripts/run.py wrapper. Each command prints one JSON envelope: read it and decide the next step from it. Step 1 only reads. Steps 2 to 5 change the project, so take them only when the task asks for a change; a question about the data stops after step 1 and reports what it found. Explore and maintain report findings and hand repair work to transform; only the transform workflow performs the project edits, migrations and dev builds described below.