Hi @Mohammed, Irfan Khan (KT) , Cross-database queries are limited to read only operations i.e. you can do a select on tables but wont be able to perform any DML operations. Below is the excerpt from official document:
"Elastic query currently only supports read-only access to external tables. You can, however, use full T-SQL functionality on the database where the external table is defined. This can be useful to, e.g., persist temporary results using, for example, SELECT <column_list> INTO <local_table>, or to define stored procedures on the elastic query database that refer to external tables."
If an answer is helpful, please "Accept answer" or "Up-Vote" for the same which might be beneficial to other community members reading this thread.