Why Do Some Destination Column Names Include the Suffix _deprecated?

Question

Why do some column names in my destination include the suffix _deprecated? There are no matching columns in my source.

Environment

All destinations

Answer

When we change a column's data type, we do the following:

1. Rename the existing column, adding the suffix _deprecated.
2. Create a new version of the column with the updated data type.
3. Drop the old version of the column.

However, if your destination contains views referencing the old column, we can't drop it. As a result, you will see the old column in your destination with the suffix _deprecated added to the name.

To see only the new column in your destination, do the following:

1. Re-create the applicable view in your destination, referencing the new version of the column.
2. Drop the old version of the column.