Bigquery data movement from stg table to main table

[dharma]

Hi,

we are streaming data to stg table and has duplicate events. Now Using some technique data has to move to main table and it should have single  and latest event. Basically our Main table should have CDC changes, Could you suggest how can we achieve this in Bigquery,? Basically Solution should have cost effective and performance.

Thanks