Delta Live Tables - skipChangeCommits in SQL

[thedatacrew]

Hi,

Could anyone tell me if the skipChangeCommits option is supported in SQL mode? I can use it successfully using Python, but it doesn't look like it is supported by SQL.

It seems to be a glaring omission from the SQL support, or support for this will come later.  Does anyone know the answer?

Thanks

[Alberto_Umana]

Hi @thedatacrew ,

The skipChangeCommits option is not supported in SQL mode for Delta Live Tables (DLT). About future support I will check internally.

[thedatacrew]

Thanks, Alberto. It would be great to know if it's in the roadmap.

[thedatacrew]

Hi Alberto,

Did you manage to get an answer?

Thanks

Toby

[Alberto_Umana]

Hi @thedatacrew,

Thanks for reaching out! I see there is already a feature request in place and it's open. https://databricks.aha.io/ideas/ideas/DB-I-12966

You might not have access to it, but you can follow up with your account team on above idea to be considered for its implementation and support.

[thedatacrew]

Thanks, I do no have access to it. I take it there no timeline on it.

[Alberto_Umana]

Unfortunately there is no ETA on this yet. If I know about it, will let you know!