The four checks that matter
1. Source preview
Use Source Configuration to confirm the selected table or resource, schema, and sample records.2. Transform preview
Use Preview with sample data in the Transform panel after each meaningful edit. In the current builder flow, this preview loads a small sample of source rows and shows the post-transform output.3. Destination preview
After saving the destination, use the Schema Preview tab in Destination to inspect the target table and recent rows.4. Manual run
Run the pipeline manually once before turning on a schedule. This is the step that proves the full source, transform, and destination path together.Step by step
- Refresh tables or resources in Source Configuration.
- Select the exact table or resource you want.
- Preview source rows.
- Update the transform script.
- Preview transform output.
- Save the script.
- Save the destination settings.
- Check destination preview.
- Run the pipeline manually.
- Verify the written rows in the destination and in Run History.
What to look for
- unexpected nulls after a cast or flatten step
- missing keys that break upsert behavior
- dropped rows you did not intend to filter out
- destination column names that do not match the script output
- differences between source preview and final destination rows