Changing Join Types

Arcadia Instant supports four basic types of column connections, otherwise known as joins: inner, left, right, and outer joins.

Developer Notes:The types of joins available depend on the underlying database. For example:
  • MySQL connections do not support FULL OUTER JOIN operations.
  • SQLite connections do not support FULL OUTER JOIN and RIGHT OUTER JOIN operations.

Briefly, here are the descriptions of the four join types:

column connection (join) types
Join Types in Column Connections Interface
Consider. By default, Arcadia Instant produces left-hand joins.

The following steps demonstrate how to change the join type.

  1. Navigate to the Data Model page of the dataset.

  2. Click Edit Data Model to edit the data model.

    Editing Table Links
    Editing Data Model
  3. Click the (link) icon that represents the connection that must be changed.

    Editing table joins
    Editing Table Joins
  4. The Join Details modal window appears.
  5. In the Join Details modal window, select an alternate join type.

    For example, instead of the default Left join, select Right join.

    changing join from Left-join to Right-join
    Changing Join Type from Left Join to Right Join
  6. Click outside the Join Details modal window. Or click Edit Join Details.

  7. Click Save.