Step 4 — EXECUTE
Run It Your Way
Execute within AutoWarehouse or export production-ready code to your existing tools. You design the pipeline — you decide how and where it runs.
Powered by Intellica's enterprise-grade orchestration engine
🤖 Agentic ETL Engine
5-phase wizard with human-in-the-loop approval at every step.
1
Analyze
Profile source database with AI classification
2
Map
Auto-suggest column mappings with reasoning
3
Build
Create ETL pipeline (DDL → Extract → Load)
4
Execute
Run pipeline with real-time monitoring
5
Report
AI-generated execution summary with stats
📦 Code Generation
Export production-ready code to your existing stack. You own the output.
⬡
Airflow DAGs
Apache Airflow workflow definitions
⬡
dbt Models
dbt transformation models
⬡
SQL Scripts
Raw SQL DDL and DML scripts
⬡
Spark Jobs
PySpark transformation jobs
⬡
Snowflake
Snowflake-optimized SQL
You're always in control. AutoWarehouse designs the pipeline — you decide how and where it runs.
Key Capabilities
Agentic ETL: 5-phase wizard with human approval
Code export: Airflow, dbt, SQL, Spark, Snowflake
DAG-based parallel execution (Kahn's algorithm)
Quality gates & data validation
SCD Type 2 load with change detection
Real-time Mission Control monitoring
Retry policies with exponential backoff