medium10 pts · first answer countssqlincremental-loads

Upserting into a target table

Your staging table has new and changed customer rows. Which SQL statement updates existing customers and inserts new ones in one step?

A.MERGE INTO target USING staging ON key WHEN MATCHED THEN UPDATE WHEN NOT MATCHED THEN INSERTB.INSERT INTO target SELECT * FROM stagingC.TRUNCATE target, then INSERT only staging rowsD.UNION ALL target and staging

← Ordering in Kafka Why use ref() in dbt →