メニュー
One-time infrastructure setup for cloud data validation — verify the orchestrator service is ready after the shared infrastructure step.
Codex または Claude でインストール この Prompt をコピーして Codex、Claude、または他のアシスタントに貼り付けると、Skill ページを確認してインストールできます。
SOC 職業分類に基づく
Identify SQL Server migration anti-patterns — performance blockers, architecture/security considerations, and behavioral differences — by running `scai assessment anti-patterns`, which buckets SnowConvert's already-recorded issue codes by priority and writes JSON for the parent assessment multi-report. Use for anti-patterns, performance/architecture concerns in SQL Server → Snowflake migrations;
Analyze SSIS packages from SnowConvert ETL.* outputs and source .dtsx files. Classifies packages, scores migration complexity, and produces JSON for the parent assessment multi-report.
Analyze Informatica Power Center workflows/mappings from SnowConvert ETL.* outputs and source XML files. Classifies workflows, scores migration complexity, and produces JSON for the parent assessment multi-report.
Analyzes workloads to be migrated to Snowflake using SnowConvert assessment reports. Routes to specialized sub-skills for high-quality assessments. Use this skill when user wants to do an assessment of their code or ETL workload, waves generation, object exclusion, anti-patterns, sql dynamic and/or ETL analysis (SSIS)
Set up a migration project — connect to source, initialize, extract objects, convert, and assess. Covers steps 1-5 of the migration lifecycle.
End-to-end database migration to Snowflake. Orchestrates the full migration lifecycle from source connection through initial conversion. Triggers: migrate, migration, migrate to snowflake, end to end migration, e2e migration, full migration.
| 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 |
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
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).
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.
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.
validation_configuration, per-table overrides, mappings, advanced). Load this when editing the file generated by validate_data(mode="setup").