Rows from the left & right inputs which meet all of the match conditions and are within the caching window, along with unmatched rows from both inputs.
Transform categories: Join
Declared arguments
Default cache time unit - Default unit for amount of time data will be cached for before eviction for both the lhs and rhs cache. Enum<Days, Hours, Milliseconds, Minutes, Seconds, Weeks>
Default cache time value - Default value for the amount of time data will be cached for before eviction for both the lhs and rhs cache. Literal<Long>
Join key - A list of columns from left and right input to join on. List<Tuple<Column<AnyType>, Column<AnyType>>>
Left columns to keep - Left columns to keep. List<Column<AnyType>>
Left dataset - Left dataset to use in join. Table
Right columns to keep - Right columns to keep. List<Column<AnyType>>
Right dataset - Right dataset to use in join. Table
optionalPrefix for columns from right - Prefix for columns from right. Literal<String>
optionalRhs cache time override - Value and unit of time that data from the rhs dataset will be cached for before eviction. Tuple<Literal<Long>, Enum<Days, Hours, Milliseconds, Minutes, Seconds, Weeks>>