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!

Can a Redshift cluster have multiple databases?

Data is organized across multiple databases in Amazon Redshift clusters to support multi-tenant configurations. However, you often need to query and join across these datasets by allowing read access.

Does Redshift have merge?

Amazon Redshift doesn't support a single merge statement (update or insert, also known as an upsert) to insert and update data from a single data source. However, you can effectively perform a merge operation.

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.