I want to use Azure Data Factory to run a remote query against a big MySQL database sitting inside a VM in another tenant. Access is via a Self-Hosted Integration Runtime, and connectivity to the other tenancy's subnet is via VNet Peering. Connectivity is good; I can see the other database, and ADF Connection succeeds.
But how do I get my SELECT statement to execute on the other machine? I don't want to bring back gigabytes of tables and select from them locally. I want my SELECT WHERE clause to execute on the MySQL database remotely and just get the very small dataset piped back to the Data Factory.
Any ideas?
