TZ100
Reputation: 318
Is it possible to run a join between two different AWS Redshift Databases in the same cluster?
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!
Upvotes: 5
Views: 3057
Answers (1)
John Rotenstein
Reputation: 269736
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.
Upvotes: 6
Related Questions
- Query against two separate Redshift clusters in a single query?
- SQL Redshift - Issue to join two tables
- Is it possible to run queries in parallel in Redshift?
- How to transfer data from a DB into another DB both in the same Redshift cluster?
- How to select tables from different databases in Redshift
- Query and join data between Amazon Redshift and Amazon RDS
- How do I complete a cross join with redshift?
- Cross joins in results
- Redshift data summarization
- AWS Redshift query multiple schema's