To add a

parent_stream

to the YAML file in Airbyte, you need to use the

SubstreamPartitionRouter

object. This object allows you to define the parent stream and other related properties for substreams that depend on the records of another stream. Here's an example of how to configure a

SubstreamPartitionRouter

in the YAML file:

yaml SubstreamPartitionRouter:   type: SubstreamPartitionRouter   parent_stream_configs:     - parent_key: "id"       stream: #/definitions/DeclarativeStream (Reference to the parent stream)       partition_field: "parent_id"       request_option: #/definitions/RequestOption (Describing where the parent key value should be injected)   $parameters:     # Set parameters that are inherited to all children

In this example, you need to replace the

stream

and

request_option

with the appropriate references to the parent stream and request option definitions. For more details on configuring

SubstreamPartitionRouter

, refer to the following extract: [SubstreamPartitionRouter

object

](https://www.reddit.com/r/Assistant_AI/comments/qzq4qf/airbyte_information_extracts/hl7zq6y/) For more information on configuring streams in the YAML file, refer to the following extract: [Understanding the YAML file](https://www.reddit.com/r/Assistant_AI/comments/qzq4qf/airbyte_information_extracts/hl7zq6y/)