I want to use the MERGE statement on an external table that we have in our data warehouse. However, the transactional table property cannot be set on an external table and thus I am not able to run any MERGE queries. Is there any workaround for this ?