Read this articles:Delta Live Tables Python language reference - Azure Databricks | Microsoft LearnThe APPLY CHANGES APIs: Simplify change data capture with Delta Live Tables - Azure Databricks | Microsoft LearnEven you could define as temporary, it ...
Have you considered use checkpoint?If you do this maybe empty dataset comes becouse there are no date in future... created_at > current_time().Read more about [Change Data Feed] Enable it in your base table and then capture only new changes feed.DLT ...
@MarkD I beleve that you don't need use a var like that.What do you think about use only a function current_time(), like that:CREATE OR REFRESH LIVE TABLE filtered
AS SELECT * FROM my_table
WHERE created_at > current_time();
