change existing table's enableChangeDataFeed configuration to be updated to True

[felipewhitaker]

Is your feature request related to a problem?

One of my customers required a column with CRUD operations (e.g. which operations have been CREATED, UPDATED or DELETED since an arbitrary past version), which I believe could be generated using delta's log.

The closest solution I found was implemented by using DeltaTable.load_cdf, but it requires having enabled enableChangeDataFeed during creation.

Is it possible to update configuration of an existing table?

Describe the solution you'd like

It would be great if it was possible to update the configuration of existing tables e.g. dtable.alter.config.enableChangeDataFeed = True.

Describe alternatives you've considered

The alternatives I found to update the table's property was via SQL e.g. "ALTER TABLE myDeltaTable SET TBLPROPERTIES (delta.enableChangeDataFeed = true)" (or using Spark), none directly from delta-rs's python.

Priority

Medium - Would be helpful

Additional context

If the best solution is by using .load_cdf and it is not possible to update this configuration, could the following approach create problems? Are there any concerns?

uri: str = ...
dtable = DeltaTable(uri)

import pyarrow as pa

schema = pa.schema(dtable.schema().to_arrow())

from deltalake import write_deltalake

write_deltalake(
    uri,
    schema.empty_table(),
    mode="append",
    configuration={
        "delta.enableChangeDataFeed": "true"
    }
)

Contribution

• I'm willing to submit a pull request for this feature
• I can help with testing this feature
• I can help with documentation for this feature

[ion-elgreco]

This is already possible, see docs: https://delta-io.github.io/delta-rs/api/delta_table/delta_table_alterer/#deltalake.table.TableAlterer.set_table_properties