Transform
Transform is where raw data from your warehouse is cleaned, joined, and computed into the tables your dashboards and reports draw from.
Dalgo runs transformations using dbt (data build tool). When you first visit Transform, Dalgo automatically creates a managed dbt workspace for your organisation — a private Git repository and a scaffolded dbt project.
Once your workspace is ready, you'll see two tabs:
| Tab | Who it's for |
|---|---|
| UI Transform | Anyone — build dbt models visually without writing SQL |
| DBT Transform | Data practitioners — run dbt commands directly and manage tasks |
You can also connect your own GitHub repository instead of using the Dalgo-managed one.
In this section
- UI Transform — visual canvas for building models
- DBT Transform — task runner and direct dbt command access
- Switching repositories — bring your own GitHub repo
Related: Ingest · Orchestrate · Data Quality