Warning: Update Your Views’ Column Names

Issue

The following warning appears on the Fivetran dashboard:

Update your views' column names.

Environment

All Connectors

Resolution

To resolve this issue, we recommend that you drop the existing views in your destination and re-create the views using your updated schema.

To achieve this efficiently, do the following:

1. Save a backup of your current view.
2. Drop the view.
3. Retrieve the old view definition.
4. Update the view definition, utilizing the new columns.
5. Execute the view.
6. Verify that the view is outputting as expected.
7. Modify the view to your required output if needed.

Cause

Due to changes in your source, we may need to change the data type of some columns. When we change a column's data type, we rename it, create a new column with the new type, and drop the old version of the column.

This issue occurs when your destination contains views that reference the old versions of impacted columns, preventing us from dropping them.