Snowflake AIM app hits public preview for migrations

Snowflake AIM began as a skill inside the Snowflake CoCo CLI and later arrived in CoCo Desktop. The new application gives it a dedicated surface built specifically for migration projects, while the CoCo CLI and CoCo Desktop remain available for users who already work in them.

The application organizes work into six stages: Connect, Initialize, Register, Convert, Assess and Migrate. Within the Migrate phase, four workstreams run with separate logic, validation and fix loops: database code testing, ETL testing, database DDL deployment, ETL pipeline migration, report repointing and historic data migration. Testing is treated as three distinct problems — database code, ETL logic and data movement — each with its own baselines and comparison methods.

Historic data migration runs on an orchestrator and worker architecture, with workers connecting to both source and Snowflake and scaling horizontally for large volumes. Validation happens automatically at three levels: schema comparison, metric comparison and optional row-level comparison. Snowflake positions the application as handling the most common migrations end to end, which it says frees partners to focus on change management and complex estates.