Updating Connections

Overview

Datasets may be re-pointed to different source locations. This can be a new connection or simply another table in the existing connection. Primarily this tool is used to rearrange similar datasets which have changed location or had minor adjustments requiring a new but equivalent underlying table or view to be created. If the composition of the fields/data has changed significantly, a new dataset should be created instead.

📄 Note

If the new source contains renamed or additional columns, fields may need to be remapped after updating the connection. See Adding & Mapping Fields.

For PostgreSQL datasets

1. Select the dataset in Mapworks UI
2. Click Advanced
3. Search for and select a connection under Update Connection
4. Select a table from the connection
5. Click Update

For datasets uploaded by file

Method 1: Re-point to an existing connection

1. Select the dataset in Mapworks UI
2. Click Advanced
3. Search for and select another file-uploaded connection under Update File
4. Select a file from the connection
5. Click Update

Method 2: Replace by file upload

1. Select the dataset in Mapworks UI
2. Click Advanced
3. Drag and drop a new file onto the Update File area

4. Click Update in the Uploads notification in the bottom right

5. Select a file from the connection
6. Click Update

Related Documentation

• Creating a Connection
• Adding & Mapping Fields
• Publication