Main workflow
- Create source and destination connections.
- Create and open a pipeline.
- Configure streams in Source.
- Add a target in Destinations.
- Create and publish destination-owned SQL in Transformations.
- Assign output tables and Upsert keys in the destination editor.
- Validate in Overview and click Run all.
- Review Runs.
- Add automation in Settings after validation.