Error: Cannot Drop Column Because Other Objects Depend on It

Issue

The following error appears in the dashboard:

Cannot Drop Column Because Other Objects Depend on It

Environment

PostgreSQL destination

Resolution

To resolve the error, you can choose any of the following solutions:

Solution 1

1. Delete the view that contains the deprecated column.
2. Wait for the sync to succeed.
3. Re-create the deleted view.

Solution 2

1. Drop the outdated columns from your destination.
2. Re-create your views.
3. Drop the old columns by running the query referenced in the error on the dashboard.

Cause

When we detect a change in the column data type, we rename the column. We then create a new column with the new data type. After that, we drop the old version of the column.

Your destination contains views referencing the old versions of these columns, preventing us from dropping them. In addition, because we no longer update the old columns, your views are outdated.