Hello! Is it possible to insert data incrementally to an input table which is also an output table? i.e. specify input table order_history, in the transformation append data to this table (today's orders) + delete records older than 7 days, so that the output table would always contain only last 7 days of orders?

3 replies