MERGE my-dataset.dimension_table as MAIN using my-dataset.temporary_table as TEMP on MAIN.PRD_SK = TEMP.PRD_SK when matched then UPDATE SET MAIN.PRD_CATEGORY = TEMP.PRD_CATEGORY when not matched then INSERT VALUES(TEMP.PRD_SK, TEMP. PRD_ID, TEMP. PRD_SK, TEMP. PRD_CATEGORY)