run_test_migration
Run a trial migration on a sample of records to produce a data quality report that flags fill rates and data loss across source, staging, and target tables.
Instructions
Trial run: sends a small sample of records (default 5) through the full migration pipeline and produces a detailed data quality report.
The report checks three layers: 1. Source (Jira/Salesforce) — what values exist in the original data 2. Staging table — what landed in the ServiceNow staging table 3. Target table — what ended up in the final ServiceNow record (e.g. Incident)
For each mapped field it shows the fill rate (% of records with a value) and flags any field that is blank in staging (source → staging data loss) or blank in the target (staging → target mapping failure).
Only call this after build_artifacts. Only call run_full_migration after the user reviews this report and explicitly says "Approved".
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| platform | Yes | Source platform (salesforce, jira, or any registered connector) | |
| object_name | Yes | Salesforce object name or Jira project key | |
| staging_table | Yes | ||
| target_table | Yes | ServiceNow target table (e.g. incident, problem, change_request — whatever the user chose) | |
| mappings | Yes | ||
| sample_size | No | How many records to test (5–10 recommended) | |
| filter | No |