Hi Team 👋🏽 While doing cost analysis I started thinking about below

Change Data Feed (CDF) includes the row data along with metadata indicating whether the specified row was inserted, deleted, or updated.

This effectively doubles storage for tables with CDF enabled. is that correct?

It depends on how much data changes. If you change the entire table twice, it will triple your storage. CDF isn’t some magic process that will give you extra features for free. Storage is fairly inexpensive in the modern world and it’s likely not something to focus on.

However if it is mostly appends with few updates, the storage cost of CDF is negligible. Really depends on the operation types and volume

thanks @JosephK (exDatabricks) that makes sense.

Nope, if it is only inserts in a transaction, no data is replicated in CDF. Under the covers it just adds the additional metadata to each record as you read it through the CDF interface. This is because the inserts are already isolated in their own files in the transaction. It is only when a transaction also includes updates and deletes that CDF has to replicate the modified data.