I’m looking to use DBT for a load and transform of data from a transactional postgres database to a simple DWH in a separate postgres instance.
The transactional db is a postgres instance running on its own server, whereas the DWH will be an RDS instance.
What would be the best way to connect the 2 with transforms etc. all don by DBT in the middle?