Error: Column Cannot Be Dropped Because It Has One or More Governed Tags Assigned

Issue

A Databricks destination connection fails with the following error:

[ErrorClass=INVALID_PARAMETER_VALUE.CANNOT_DROP_TAGGED_COLUMN] Column cannot be dropped because it has one or more governed tags assigned.

Environment

Destination: Databricks

Resolution

To resolve this issue, do the following:

1. In your Databricks workspace, use Unity Catalog to identify the governed tags assigned to the affected columns.
2. Remove all governed tags from the columns Fivetran needs to drop. For more information, see the Databricks documentation on dropping a column with governed tags.
3. In Fivetran, go to the affected connection overview page.
4. In the top right, click Sync.

Cause

This issue occurs when we attempt to drop a column during a schema change, but the column has Unity Catalog governed tags in Databricks. Databricks enforces a permission constraint that prevents dropping tagged columns.