UPSERT INTO dataset <QUERY> requires upsert privilege on dependent datasets.

UPSERT INTO dataset <QUERY> requires UPSERT privilege on dependent datasets and does not require SELECT privilege on the dependent datasets.

upsert into airport (select city from landmark);

It should have required SELECT privilege on the landmark collection instead of UPSERT.