Data migration and data validation¶
Data migration is copying rows from a source system into Snowflake tables (historical loads, partitions, and optional incremental runs). Data validation checks that what landed in Snowflake matches what you expect from the source (row counts, sampled values, hashes, or dialect-specific strategies). The Snowflake Migration Agent combines both in stage Migrate, alongside SnowConvert’s cloud data migration stack and the standalone Snowflake Data Validation CLI documented elsewhere in this tree.
Data migration and validation in the Snowflake Migration Agent¶
The agent’s guided workflow explicitly covers deployment, data movement, and checks after SQL conversion:
| Capability | What it means |
|---|---|
| Migrate data | Copy rows from source tables into Snowflake with automatic row-count validation as part of the flow |
| Validate data | Compare row counts and data between source and Snowflake tables after migration to confirm completeness |
migrate-objects | Deploys objects wave by wave; for tables, deploys to Snowflake then migrates data from the source |
Procedure-level assurance uses baseline-capture and the migrate-objects test loop (two-sided validation of function and procedure output against captured baselines). That complements table-level migration and validation above.
Example prompt (from the Snowflake Migration Agent topic):
Platform availability for cloud data migration and cloud data validation appears in the Supported source systems table in the Snowflake Migration Agent (for example SQL Server and Redshift today for some paths, with additional sources on the roadmap for migration).
If you want to explore further, the SnowConvert AI technical documentation for data migration (DM) and data validation (DV) is where you will find fuller answers on architecture and how to use the products: how orchestrators and workers connect to sources and Snowflake, which scai data … commands apply, how workflows are authored and monitored, and what metadata and dashboards to expect while jobs are running.
SnowConvert AI: Data migration [Preview] is the place to start for DM. SnowConvert AI: Data validation [Preview] is the matching deep dive for DV.