3 ms·
Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon
by kyleblarson 10y ago
Agree 100%. Would be awesome if you could have RDS with FDW connected to a Redshift instance. (don't know if that's possible given the version of Postgres upon which Redshift is based)
- numlocked 10y agoYou can definitely do FDWs to Other Postgres instances, and since I think you can just point the same wrapper to redshift and voila.
- yuanchuan 10y agoIt is definitely doable. You can refer to this blog post by AWS (https://aws.amazon.com/blogs/big-data/join-amazon-redshift-and-amazon-rds-postgresql-with-dblink/ https://aws.amazon.com/blogs/big-data/join-amazon-redshift-a...) to set up FDW to Redshift. What is more exciting is you can leverage Redshift MPP architecture with this method.