Converting ETL¶
Converting ETL means moving legacy data integration jobs to Snowflake by separating transformation (how data moves between sources and targets) from orchestration (when jobs run, dependencies, and variables). On Snowflake, transformation typically lands in dbt projects on Snowflake and orchestration maps to native Snowflake constructs such as tasks and stored procedures. The Snowflake Migration Agent drives this conversion for SSIS and Informatica PowerCenter workloads, on top of SnowConvert AI’s Replatform engine and the related translation references documented elsewhere in this tree.
ETL conversion in the Snowflake Migration Agent¶
The skill treats ETL as a first-class capability alongside SQL conversion, assessment, and data migration:
| Capability | What it means |
|---|---|
| Convert ETL pipelines | Translate SSIS packages and Informatica workflows toward dbt using deterministic conversion, with optional AI-assisted remediation for remaining gaps |
| Assess workloads | The interactive HTML report includes SSIS / Informatica ETL analysis (package classification, control- and data-flow mapping, effort estimates) alongside waves, exclusions, and dynamic SQL |
| Output layout | Replatform output lands under Output/ETL/ with shared etl_configuration/ plus per-package folders that combine orchestration SQL (tasks or procedures) with per-data-flow dbt projects (staging, intermediate, marts) |
The conceptual mapping from source ETL constructs to Snowflake artifacts looks like this:
| Source concept | Typical SnowConvert AI output role |
|---|---|
| SSIS Data Flow Task | Standalone dbt project (transformation) |
| SSIS Control Flow | TASK or procedure (orchestration) |
| SSIS variables | control_variables-style infrastructure plus dbt variables |
| Informatica mapping / workflow | dbt models plus orchestration tasks |
Example prompts (from the skill topic):
Platform availability for SSIS to dbt, Informatica to dbt, and the corresponding AI conversion paths appears in the Supported source systems table in the Snowflake Migration Agent (deterministic and AI-assisted conversion are available across SQL Server, Redshift, Teradata, Oracle, and other source systems).
If you want to explore further, the SnowConvert AI documentation for ETL migration is where you will find fuller answers on architecture and how to use the products: how Replatform splits transformation from orchestration, the full project setup and UI flow, configuration of sources.yml / profiles.yml / dbt_project.yml, deployment and run steps, and the EWIs surfaced during conversion.
SnowConvert AI: ETL migration (Replatform) is the place to start for the end-to-end Replatform flow. SSIS translation reference and Informatica PowerCenter reference are the matching deep dives for component-level behavior, supported objects, and expression coverage. Issues surfaced during SSIS-to-dbt conversion are catalogued in the ETL Replatform Issues report.