My project has Maria DB as on-prem source system, it is connected with ADF via Self hosted integration runtime. I want to copy only the required fields from 100 tables of MariaDB to Data Lake but I want to make sure that the query is executed on Maria DB and not on Azure side due to strict data policies of my organization. Is there any way to achieve this? I read that if we execute the SQL query in copy activity, it is staged in Azure via SHIR which means it goes through organization network and firewall which I dont want.

I created a copy activity, provided all the details of source environment – MariaDB and observed that it has preview data section which will defeat the purpose of bringing only the required fields into Azure as I can see all the columns in preview section