Scale Intelligence■ Docs
Docs / The model / SourceJoin

SourceJoin.

One join from a table of a read artefact to another source, by an identifier

Figure 1SourceJoinspecified
SOURCEJOINvalue at none scopethe source, schema, table and column on this sidelefttextthe source, schema, table and column on the other siderighttextthe kind of identifier the join is on, where the reading names itidentifier_kindtextoptionalhow the join is known: inferred from the column names, stated by the generator, or measuredbasistextpoints at no other object
SourceJoin is a value at none scope. The drawing shows its fields and the objects that they point at.
kind
value
scope
none
key
none
store
none
family
sources

Fields#

fieldtyperequirednote
lefttextyesthe source, schema, table and column on this side
righttextyesthe source, schema, table and column on the other side
identifier_kindtextnothe kind of identifier the join is on, where the reading names it
basistextyeshow the join is known: inferred from the column names, stated by the generator, or measured

Routes that use it#

No route takes or returns SourceJoin directly. The record holds it, and the objects that point at it reach it.