I need to create a dataset that is dependent on multiple streaming datasets. However, when I attempt to create the new single stream I am getting an error.

Append output mode not supported when there are streaming aggregations on streaming DataFrames/DataSets without watermark;

Example:

create or refresh streaming live table silver_customer;

create temporary streaming live view customer_updates

as

with listOfCustomers as

(

select CustomerID

from

 stream(live.raw_Customer)

union

select CustomerID

from

 stream(live.raw_CustomerAddress)

)

select CustomerID

from listOfCustomers;

apply changes into 

 live.silver_customer

from

 stream(live.customer_updates)

keys(CustomerID)

sequence by CustomerID

stored as scd type 1;