Change a column name in a source table
You can change the column names in a source table.
If a data type of a source table has changed, for example from Long to String, the subsequent extraction will fail because of the data type mismatch in the source table. A warning is displayed at the table and a message is displayed in the run log of the extraction. You must change the column name of the affected column in the corresponding source table.
If you rename a column of an incremental table, the original column including the data of the last extraction remains in the source table during the next extraction. In addition, a new column is created with the changed name. The new column contains the data from this extraction time.
Open the Extractions section of a data set.
Click a JDBC extraction in the Extractions list. The Tables page of the selected extraction opens.
Click the ... button of a table -> Configure assigned source table.
The type of the source table is preselected.
Click Next.
If you selected a table of Table type, the Target column names dialog opens.
If you selected a table of Incremental type, the Source table merge key dialog opens. Click Next to open the Target column names dialog.
Enter a target column name used for the extracted source column. By default, the original source column name is used as target column name.
Click Done.
You changed the column name of source column.