AWS – Announcing General Availability of Amazon Redshift Cross-database queries
Amazon Redshift Cross-database queries provide ability to query across databases in a Redshift cluster. This feature is now generally available in all regions where Amazon Redshift RA3 node types are available. With Cross-database queries, you can seamlessly query data from any database in the cluster, regardless of which database you are connected to. Cross-database queries can eliminate data copies and simplify your data organization to support multiple business groups on the same cluster. Cross-database queries can be used on your RA3 clusters at no additional cost.
Read More for the details.