Seems like the error is from the some_bq_view's definition, which likely has a faulty FOR SYSTEM_TIME AS OF clause. Correct or remove the time travel within the view's SQL and recreate it to fix your MERGE query.