To extract a nested value for your substream partition router, you can use the SubstreamPartitionRouter component. You'll need to configure the following fields: 1. Parent stream: Define the records of which stream should be used as partitions. 2. Parent key: Specify the property on the parent stream record that should become the partition value (in most cases, this is some form of ID). 3. Current partition value identifier: Choose an identifier for the variable holding the current partition value. You can use this identifier in the path of the stream using the

{{ stream_partition.<identifier> }}

syntax. Here's an example of how to configure the SubstreamPartitionRouter component:

yaml partition_router:   type: SubstreamPartitionRouter   parent_stream_configs:     - parent_stream: parent_stream_name       parent_key: nested_key_name   current_partition_value_identifier: chosen_identifier

In this example, replace

parent_stream_name

with the name of the parent stream,

nested_key_name

with the nested key you want to extract, and

chosen_identifier

with the identifier you choose for the current partition value. For more information on the SubstreamPartitionRouter component, refer to the [documentation](https://docs.airbyte.com/connector-development/config-based/understanding-the-yaml-file/reference#SubstreamPartitionRouter).

Apologies for the confusion earlier. You are correct that the term

current_partition_value_identifier

is not mentioned in the Airbyte documentation. I made an error in my response. To extract a nested value for your substream partition router, you should configure the "Parent key" field to point to the nested property you want to use as the partition value. You can use dot notation to access nested properties. For example, if your parent stream record looks like this:

json {   "id": 123,   "details": {     "nested_id": 456   } }

You can set the "Parent key" field to

details.nested_id

to use the nested value as the partition value. Please refer to the [Substream partition router documentation](https://docs.airbyte.com/connector-development/connector-builder-ui/partitioning#dynamic-and-static-partition-routing) for more information on configuring the partition router.

New message text here