analyze_migration_for_testing
Inspect staging tables, target tables, transform maps, and source data quality to identify migration risks and recommend test coverage areas.
Instructions
Analyze a migration setup to identify risks and plan expert test coverage.
Inspects:
Staging table accessibility and write permissions
Target table accessibility
Active transform map between staging and target
All mapped SN target fields exist
Correlation/deduplication field presence
Source data quality (null rates, long text) from sample records
Transform rule coverage
Risk scoring: HIGH (blockers) / MEDIUM / LOW
Returns a full analysis with recommended test coverage areas and estimated test count.
Always call this FIRST before create_migration_test_plan.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| platform | Yes | Source platform: jira or salesforce | |
| source_object | Yes | Jira project key or Salesforce object name (e.g. KAN, Case) | |
| staging_table | Yes | ServiceNow staging/import table name (e.g. u_imp_jira_kan) | |
| target_table | Yes | ServiceNow target table name (e.g. incident, problem) | |
| field_mappings | No | ||
| transform_rules | No | ||
| sample_records | No | Optional: pass source records already fetched — enables null-rate and length analysis |