Can I join multiple collections?
Yes, you can join multiple collections in Rockset!
Using SQL you can perform ARRAY_JOINs, INNER JOINs, LEFT or RIGHT OUTER JOINs, and CROSS JOINs to join collections. You can view our SQL JOIN documentation here.
You can also view join optimization strategies for the four join strategies Rockset supports (Hash Join, Nested Loop Join, Broadcast Join, and Lookup Join) here.
If you’re interested in learning about streaming SQL joins in Rockset, check out this awesome blog post written by one of our solutions engineers. The post explains how you can join data from multiple collections using SQL joins at query time and ingestion time!