Is it possible to run a join between two different

2019-07-04 01:23发布

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!

1条回答
三岁会撩人
2楼-- · 2019-07-04 02:22

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.

查看更多
登录 后发表回答