Error: F_JD0E02 Database Does Not Have Column Modify Capabilities

Issue

After a source column's data type changes, Capture detects the change through AdaptDDL and triggers a refresh job. Integrate then fails while applying the change to the Databricks target with the following errors:

• ALTER TABLE xxxxx.FT_TEST ADD COLUMN new_col2 numeric(10,3);
• ALTER TABLE xxxxx.FT_TEST ALTER COLUMN new_col2 type DOUBLE PRECISION;
• F_JD0E02: Attempt to alter table modify column of table [bronze_fivetran_poc.xxxxx], when database does not have column modify capabilities. \
• F_JT0F00: The previous error occurred while cloning table 'ft_test' in schema 'bronze_fivetran_poc'. \
• F_JG0E65: The previous error occurred during task to (re) create target tables during refresh with arguments {}.

Environment

• HVR 6
• Target: Databricks

Resolution

To resolve this issue, enable the delta.enableTypeWidening property on the affected Delta table, then retry the refresh job in HVR. For more information, see the Databricks documentation on type widening.

Cause

Databricks doesn't support column type modifications by default. The delta.enableTypeWidening property enables supported type-widening changes.