Skip to main content
The pipeline builder guides you through each step. Follow this walkthrough to create a pipeline from start to finish.
1

1. Choose source connection

Select the source connection from the dropdown. Only connections you have created appear. If you need a new connection, create it first in Connections.
2

2. Choose destination connection

Select the destination connection. Again, create the connection in Connections if it does not exist.
3

3. Select streams

Choose which streams (tables or data feeds) to sync. You can select one or more. Each stream will sync to a table or collection in the destination.
4

4. Set sync mode

For each stream, choose the sync mode: Full sync, Incremental sync, or CDC (if supported). For incremental, select the cursor column (e.g. updated_at).
5

5. Set write mode

Choose how to write to the destination: Append, Replace, or Upsert. For upsert, specify the primary key column.
6

6. Column mapping (optional)

Optionally rename columns or select only specific columns. By default, all columns are synced with their original names.
7

7. Transformation rules (optional)

Add transformation rules: rename, cast, filter, add column, fill nulls, or custom rules. Rules are applied in order before writing to the destination.
8

8. Review and save

Review the configuration. Click Save to create the pipeline. You can run it immediately or configure a schedule.