Managing your Connections

A connection tells Dalgo what data to sync from a saved source into your warehouse.

If a source answers "where does the data live?", a connection answers "which data should be copied into the warehouse, and how should it sync?".

1. Click the Connections tab in the Ingest section.
2. To add a new connection, click + New Connection.

3. Give your connection a name and select the source you want to sync. The available source tables or streams will appear in the streams column.

4. Select whether you want the data to be normalised.
5. Turn on sync for the relevant streams or tables from that source.
6. Choose how you want the data to sync, then click Connect.
7. To test your configuration, click the Sync button on the right side of the connection row. The sync will begin to run and logs will populate in the section below.

Schema changes

If columns or fields change in your source data, Dalgo detects those schema changes on the relevant connection and shows them as pending changes.

1. Dalgo automatically detects additions, removals, or changes to columns in your source tables.
2. When a change is detected, a Pending Changes section appears in Ingest and lists the affected connections.

3. Click View next to a connection to review what changed.
4. You can approve or ignore those changes. If you approve them, Dalgo updates the connection and the pending changes entry disappears.

5. If a change removes a critical field, such as a cursor field, Dalgo treats it as a breaking change. These changes cannot be approved in Dalgo and must be fixed at the source.
6. After approved changes are applied, future syncs will use the updated schema.

Note: Make sure schema changes are compatible with your downstream models and dashboards. If you are unsure, check with your data team or contact support@dalgo.org.