Can we join streaming table and live table in delta live table

[-werners-]

If you mean a stream-static join, yes that is possible:

https://learn.microsoft.com/en-us/azure/databricks/delta-live-tables/transform#--stream-static-joins

If not, what exactly do you mean?

[PK225]

If we have one table from kafka source and another table is streaming table from external source. Can we join these two tables into single table?

[-werners- · Accepted solution]

In theory yes, see this SO topic.

However, also mind the remarks given (watermarks etc).

[PK225]

Thanks for your response