Databricks Community

n_joy

I have a Delta table already created, with both enabled the #enableChangeDataFeed option and #allowColumnDefaults properties. However when writing to CDC table with streaming queries it fails with the following error [CREATE TABLE command because it ...

n_joy

@filipniziolYes, that is what I do  Thanks for feedback !

n_joy

@filipniziolHi! Thank you for your response! Please see my comments above.

n_joy

Case is the following: "For some reason, the Change Data Feed feature recognizes DEFAULT columns from the source but does not enable this property when creating a _cdc table.": So it uses the following DDL that is impossible to execute: Instead of th...

n_joy

ERROR:[WRONG_COLUMN_DEFAULTS_FOR_DELTA_FEATURE_NOT_ENABLED] Failed to execute CREATE TABLE command because it assigned a column DEFAULT value, but corresponding table feature was not enabled. Please retry command again after executing ALTER TABLE tab...

Databricks Community

User Stats

User Activity

Change data feed for tables with allowColumnDefaults property "enabled"

Re: Change data feed for tables with allowColumnDefaults property "enabled"

Re: Change data feed for tables with allowColumnDefaults property "enabled"

Re: Change data feed for tables with allowColumnDefaults property "enabled"

Re: Change data feed for tables with allowColumnDefaults property "enabled"