Joining across databases

I received an email in October offering an invitation to a "Early Access Group" for a new feature joining data in reports across multiple databases. At the time I said yes but I wasn't super interested. I now have a need for this type of reporting but I never heard anything back about it.

Was wondering if this is something coming out in the near future?
if not..

  1. should I move in the data factory direction and spend $$
  2. is there some fancy way to do this with models or something

Essentially my setup is
6 servers running postgres with the same schema
1 corporate server running postgres that combines all the data via rsync once a night - as much as I want to, I can't increase this frequency for operational reasons out of my control

I mostly run queries against the corp DB and its sufficient but occasionally I want Live up to date Data straight from the 6. I can use Dashboards and get an effect close to what I want but all the data is on different report squares of course.

I wouldn’t use rsync but rather Postgres foreign data wrapper