Transformations in Weld
Weld gives you two powerful ways to handle data transformations:
- Weld Transform β build and schedule models directly in Weld with our SQL editor.
- Third-party orchestration β integrate dbt, dbt Core, or warehouse/BI tools while Weld manages ingestion, orchestration, and reverse-ETL.
π Weld Transform
Weldβs built-in SQL editor connects directly to your destination (warehouse), so you can write, test, and run SQL models inside Weld.
This is ideal if you want to keep everything in one place.
Read more about Data Models, including drafts, published models, and table references.
Key capabilities
AI assistant β get SQL help, debugging, and suggestions from Ed- Data Lineage β visualize model dependencies
- Version Control β track and roll back changes
- Scheduling β run models automatically
- Realtime collaboration β edit and build models with your team live
π Third-party Orchestration
Prefer using external tools like dbt or BI platforms? Weld integrates with them too.
You can plug your transformation tool of choice into Weldβs orchestration layer to create end-to-end automated workflows.
Why use third-party orchestration?
- Keep using familiar tools (dbt, dbt Core, Power BI, Fabric, Looker Studio, Snowflake SQL, etc.)
- Weld handles ingestion and reverse-ETL around your transformations
- Orchestrate everything in one place with consistent scheduling and monitoring
- Reduce manual coordination across multiple platforms
Supported options
- dbt Cloud β trigger dbt jobs directly from Weld
- dbt Core β run dbt Core externally while Weld powers ingestion + activation
- Other / Webhooks β continue modeling directly in your warehouse or BI tool (BigQuery, Snowflake, Power BI, Fabric, Looker Studio, etc.)
Weld doesnβt replace your existing tools β it connects and orchestrates them as part of your workflows.
Next steps
- Explore Weld Transform in detail through the sidebar pages β
- Or jump into Third-party orchestration to connect your existing tools