| name | data-validation-setup |
| description | One-time infrastructure setup for cloud data validation — verify the orchestrator service is ready after the shared infrastructure step. |
| parent_skill | migration |
| license | Proprietary. See License-Skills for complete terms |
Cloud Data Validation Setup
One-time infrastructure setup for validating migrated data between a source database and Snowflake using the Cloud Data Validation feature via the scai CLI.
Supported sources: SQL Server, Redshift, Oracle, Teradata, PostgreSQL
Supported target: Snowflake
Prerequisite
Load ../../data-infrastructure/SKILL.md first. It handles shared prerequisites, compute pool registration, and worker config (source host/port/credentials, source database, source schema). Return here after it completes.
Validation additionally requires that target tables are already deployed to Snowflake (run data migration first).
Step 1: Verify Orchestrator Service
After the shared infrastructure step has registered the compute pool, confirm the orchestrator service started:
SELECT SYSTEM$GET_SERVICE_STATUS('SNOWCONVERT_AI.DATA_MIGRATION.DATA_MIGRATION_SERVICE');
If it returns [] (suspended/not started), resume it manually:
ALTER SERVICE SNOWCONVERT_AI.DATA_MIGRATION.DATA_MIGRATION_SERVICE RESUME;
Wait 30-60s and re-check until status shows READY.
This completes infrastructure setup. The actual validation is started later by the validate-objects skill via:
validate_data(mode="setup", where=...) — generates artifacts/data_validation/workflows/<hash>.yaml.validate_data(mode="run", workflow_path=...) — runs the orchestrator + worker + validate create-workflow lifecycle.
Do not run scai data validate create-workflow directly — validate_data handles service and worker lifecycle internally.
Checklist
Shared infrastructure checklist is owned by ../../data-infrastructure/SKILL.md. Validation-specific items:
- [ ] Compute pool registered (configure(compute_pool=...))
- [ ] Worker config has no remaining <placeholder> values — unless pure Iceberg
- [ ] Level 1 scai data doctor — no Fail checks (see data-infrastructure skill)
- [ ] Data Validation Service running (READY)
Return control to the parent skill.
Reference
