Skip to main content
ETL is the default Job type: read from a source connection, optionally transform in transit, and write to a destination. Create and operate ETL from Data → Jobs.

​
Create an ETL Job

  1. Go to Data → Jobs → New Job.
  2. Complete the wizard: Source → Destination → Tables → Field Mapping → Configure.
  3. On Configure (advanced), set Job Type to ETL if it is not already.
  4. Choose sync mode and destination write mode, then click Create Job.
The product path is Data → Jobs, not a separate “Pipelines” sidebar item. Docs may say “pipeline” when describing the Job’s data flow.

​
Source sync modes

See Sync modes.

​
Destination write modes

Labels on Destination Mode:
  • Prefer Upsert when the source has a primary key and rows can change.
  • Use Append for immutable streams (events, logs) or sources without a usable PK.
Sync mode and destination write mode are locked after the Job is created. Create a new Job if you need different modes.

​
Table selection

On the Tables step, Zwiron lists tables discovered from the source catalog (after profiling / scan). You can:
  • Select individual tables or schemas
  • Search by name
  • Enter table names manually when the UI offers manual mode
Destination schema defaults from the source connection name (for example Prod Postgres → prod_postgres). Override on Configure when needed. Overlapping schemas may show a conflict warning without blocking create.

​
After create

  1. Open the Job from Data → Jobs.
  2. Click Rerun (or wait for schedule).
  3. Use Runs → View Logs and monitoring tabs as needed.
Last modified on October 10, 2026