DLT streaming table and LEFT JOIN

[Daba]

I'm trying to build gold level streaming live table based on two streaming silver live tables with left join.

This attempt fails with the next error:

"Append mode error: Stream-stream LeftOuter join between two streaming DataFrame/Datasets is not supported without a watermark in the join keys, or a watermark on the nullable side and an appropriate range condition".

My question is how I can implement the watermark with SQL interface? Where can I find examples?

Thanks.

[Daba]

Thanks Fatma,

I do understand the need for watermarks, but I'm just wondering if this supported by SQL syntax?

[TomRenish]

I'm wrestling with similar questions. This article makes it pretty clear that you'll need to use scala/python/java/r: streaming writes

[NateAnth]

It is now!

https://docs.databricks.com/sql/language-manual/sql-ref-syntax-qry-select-watermark.html