Is there a function in delta lake OSS corresponding to `tabl

Question

Is there a function in delta lake OSS corresponding to `table changes` for reading from the change data feed <https docs databricks com sql language manual functions table changes html>

Marius Grama · Answer

While going through the delta lake oss code I came over <https github com delta io delta blob e0e9b0095dcc5b1c4372474a54c87428340fe899 core src main scala org apache spark sql delta commands cdc CDCReader scala L41|https github com delta io delta blob e0e9b0095dcc5b1c4372474a54c87428340fe899 co n scala org apache spark sql delta commands cdc CDCReader scala> But there is apparently no SQL function exposing this functionality

Christopher Grant · Answer

IMO it s difficult to push delta specific functionality in this case custom syntax to Spark feel free to open an issue on the Delta github if there isn t one already

Scott Sandre (Delta Lake) · Answer

Just merged into master <https github com delta io delta commit 94b902050c400e7b33657dafa322387578af2535>

Scott Sandre (Delta Lake) · Answer

Expect this in the next 2 3 Delta Lake release

Scott Sandre (Delta Lake) · Answer

cc < Allison Portis>

Marius Grama · Answer

Thank you Scott Great news That s a nice feedback

Marius Grama · Answer

You can update now <https github com delta io delta issues 1307> gt Support querying Change Data Feed CDF using SQL queries