Assessment

Assessment is how you understand what you are migrating before you commit to conversion and cutover. Strong assessments inventory objects and dependencies, highlight complexity and risk, and support a realistic migration sequence. In this documentation, assessment shows up in two main places: the Snowflake AIM Agent for Data Warehouses, and Snowflake AIM Agent for Spark Workloads.


Assessment inside the Snowflake AIM Agent for Data Warehouses

When you work through the Snowflake AIM Agent for Data Warehouses, the assessment stage generates a single self-contained multi-tab HTML report. You can run the analyses individually or together:

AnalysisWhat it does
Deployment wavesUses object dependencies to order deployment so dependents come after prerequisites.
Object exclusionSurfaces temporary, staging, deprecated, and test artifacts so you can shrink scope before deployment.
Dynamic SQL analysisClassifies dynamic SQL patterns and highlights native Snowflake coverage vs manual rewrite vs higher complexity.
ETL or SSIS assessmentClassifies SSIS packages (ingestion, transformation, export, orchestration, hybrid), maps control and data flow, and estimates migration effort.

Assessment inside the Snowflake AIM Agent for Spark Workloads

For Spark API workloads moving toward Snowpark, Snowflake AIM Agent for Spark Workloads starts with an assessment that goes beyond simple pattern matching: it builds a semantic model of your codebase. See How the assessment works.

Outputs include

  • A readiness score (see the glossary)
  • A full list of Spark API references and how they align with Snowpark
  • Third-party library imports and compatibility context
  • A summary report pulling the inventories together

Generated files from assessment mode are described under Output reports.

The Assessment landing page lists step-by-step and interpretation topics:

Start from Snowpark Migration Accelerator: Assessment for the full outline.


Choose your path

If you are assessing…Start here
Data Warehouses such as SQL Server or RedshiftSnowflake AIM Agent for Data Warehouses assessment
Spark API code for SnowparkSnowflake AIM Agent for Spark Workloads assessment