Tejas2022
New Contributor II

@diego_poggioli 

Can you try selecting a 'year_month_version' column from the view instead of select *

 

DELETE FROM dev.gold.table AS trg
   WHERE year_month_version IN (select year_month_version FROM v_distinct_year_month_version)

 

 

Tejas Bhorade