In order to perform a cross-database join, all of the tables in the query must exist on the Periscope cache. Customers on MySQL and SQL Server may already be familiar with cross-database joins for database that are on the same host.
Note: Cross-Database Joins are only available with the cache add-on.
We have two databases,
ExampleTwo. In our query we want to join
Dog table with
Animal table. Our query looks like:
Table names can also be aliased to clear up some ambiguity:
If an error is returned an error while trying to do a cross-database join, double check that the all tables used in the join are cached and that the syntax is Redshift-compatible.