I'm working on a tap that has four streams. I need to combines the result of three streams to use as parameters passed to the fourth stream to the API. Here is a simple example

get all unique col values from stream_1 -> [A, B]
get all unique col values from stream_2 -> [1, 2]
get all unique col values from stream_3 -> [red, blue]
we need to create combinations of each group and pass each to stream_4
combinations = [
  [A, 1, red],
  [A, 1, blue],
  [A, 2, red],
  [A, 2, blue],
  [B, 1, red],
  [B, 1, blue],
  [B, 2, red],
  [B, 2, blue],
]
call stream_4 for each combo in combinations, passing them as url params

How could I implement this?