Table migration

Table Migration moves data from one table to another, usually between two different databases. It’s commonly used in ETL workflows to:

• Copy or sync data from one environment to another
• Transfer data across platforms, like from a staging area to production
• Keep datasets up to date between connected systems

This step helps ensure data is accurately transferred and ready for use in the target system.

How to use Table Migration?

Step 1: Select the source connection using the “Connection From” field.

Step 2: Select the destination connection using the “Connection to” field.

Step 3: Choose the table from the source database that the user wants to migrate.

Step 4: Choose the table from the target table where the data should be loaded.

Step 5: Mode: Choose how the data should be migrated:

• Append: Adds new data to existing records without deleting anything.
• Truncate and Load: Deletes all existing data in the destination table before loading new data.

Step 6: Enable “Map columns” if the user wants to map specific columns from source to destination.

The Map Columns interface allows you to match fields from the source table to fields in the destination table during table migration. This is especially useful when the column names or their order do not match between the source and target tables.

Upon enabling, the user can edit it.

Step 7: Click “Save.”

For example:

• We selected “etl_connection” as the source connection.
• Selected “SnowPartner” as the destination connection.
• Select the source and destination tables, then choose the “Append”
• We have enabled “Map columns” and clicked on edit.

Note: The user can migrate up to 10 tables in one operation.