topic Re: Can we join streaming table and live table in delta live table in Data Engineering

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

PK225 — Wed, 07 Jun 2023 06:40:53 GMT

-werners- — Wed, 07 Jun 2023 06:46:36 GMT

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

If not, what exactly do you mean?

PK225 — Wed, 07 Jun 2023 07:30:53 GMT

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- — Wed, 07 Jun 2023 07:42:33 GMT

In theory yes, see this SO topic.

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

PK225 — Wed, 07 Jun 2023 07:45:35 GMT

Thanks for your response