google bigquery - Cannot query over table without a filter that can be used for partition elimination

Question

I have a partitioned table and would love to use a MERGE statement, but for some reason doesn't work out.

MERGE `wr_live.p_email_event`  t
using `wr_live.email_event` s
on t.user_id=s.user_id and t.event=s.event and t.timestamp=s.timestamp
WHEN NOT MATCHED THEN
INSERT (user_id,event,engagement_score,dest_email_domain,timestamp,tags,meta)
values (user_id,event,engagement_score,dest_email_domain,timestamp,tags,meta)

I get

Cannot query over table 'wr_live.p_email_event' without a filter that can be used for partition elimination.

What's the proper syntax? Also is there a way I can express shorter the insert stuff? without naming all columns?

Answer 1

Waitting for answers