I am not sure about the exact issue here, but there are some guidelines in general when streaming data from another table. first Make sure the tables that you are streaming form are Delta tables. also the best way to stream changes form a table is through CDF if there are too many updates, or deletes if it is all inserted, then use streaming. One thing you might explore to simplify this is to use Delta Live Table Streaming(<table-name) function.