Merge tables in GBQ

PHOTO EMBED

Tue Jan 18 2022 03:09:49 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #sql

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)
content_copyCOPY

https://cloud.google.com/architecture/bigquery-data-warehouse