I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use `PartitionKeyPaths`, But there is no option to configure path in output settings

Question

I am trying to configure cosmos db output in stream analytics job, getting error as This subpartitioned container has more than 1 partition key path please use PartitionKeyPaths, But there is no option to configure path in output settings.

How this can be configured?

Answer 1

Hi @Rajesh Karuppiah

Greetings & Welcome to Microsoft Q&A forum! Thanks for posting your query!

To resolve the issue, you are encountering with configuring Azure Cosmos DB output in your Stream Analytics job, you need to ensure that you're using the correct partition key configuration.

This subpartitioned container has more than 1 partition key path please use PartitionKeyPaths

The error message indicates that your subpartitioned container has more than one partition key path, which requires you to specify PartitionKeyPaths.

But there is no option to configure path in output settings.

Unfortunately, the output settings in Azure Stream Analytics do not provide an option to configure partition key paths directly. You may need to ensure that your Cosmos DB container is set up correctly with a single partition key path before connecting it to your Stream Analytics job.

How this can be configured?

If your container is already configured with multiple partition key paths, you will need to either modify the container to use a single partition key path or create a new container with the appropriate configuration.

I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.