If I have two database located on cloud and local. Whether the “Executor” should be deploy near by the database, means one on cloud another in local network, then a “Coordinator” will control those two in a “Dremio Cluster”?
It should be make sense I wont to transfer too many data on internet.
3 options (ideally only 2 for you)
#1 Have the executors either on the cloud or on-prem then one of the reads will be expensive
#2 Have 2 separate Dremio clusters one for each but cannot join the data
#3 Use the feature Multi Cluster Isolation but this is a EE only feature, here you can direct certain queries to certain nodes