'Getting streaming buffer error, but I don't using streaming for my usecase

Getting error running this query:

MERGE <base_table> t1
USING (
  SELECT *
  FROM (
    SELECT distinct * 
    FROM <table_changes>
    WHERE timemodified = (
           SELECT MAX(timemodified) 
           FROM <table_changes> t4 WHERE t3.company = t4.company)
    ) t3
ON t1.company = t2.company
WHEN MATCHED THEN
UPDATE SET <assign values>
WHEN NOT MATCHED THEN
INSERT (<columns>) VALUES(<columns>)

Error:

UPDATE or DELETE statement over table connecteam-data-prod-v1.ct_internal_state_based_data.company_profile_meta_data_t would affect rows in the streaming buffer, which is not supported

But I don't use any streaming for this table. How can I resolve it?



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source