just wondering if this is possible? I see some older links stating this is not possible from 2015 or so but wondering if it is now and if there is any available documentation that states yay/nay. Thanks!
Asked
Active
Viewed 2,756 times
1 Answers
6
It is not possible to queries across or JOIN logical databases created via the CREATE DATABASE command.
This is the same for PostgreSQL, on which Amazon Redshift was based. See: Joining Results from Two Separate Databases
While PostgreSQL has the dlink module that can join separate databases (on the same cluster or otherwise), this capability is not available for Amazon Redshift.
John Rotenstein
- 241,921
- 22
- 380
- 470