are there any ways to join two tables from two different databases?
If you use Postgres, you could use Postgres foreign data wrappers. If that’s not the case, you should use any solution that allows you to do query federation (e.g. trino/presto, redshift, Bigquery)
1 Like