PartitionKeyVersion is NULL for the Azure Cosmos Container

Sai Praneeth Eranti 170

The Microsoft documentation states that when creating a new container, the PartitionKeyVersion should be either 1 or 2, not NULL. However, when using PowerShell script to create a container without specifying "PartitionKeyVersion," it is being created with a value of NULL. This behavior seems incorrect. What could be causing this issue?

PowerShell which I'm using is here

ShaktiSingh-MSFT 16,086 Reputation points

2024-12-17T12:33:40.65+00:00

Hi Sai Praneeth Eranti •,

Welcome to Microsoft Q&A forum.

Could you please share the details of the documentation you have shared in the question for us to look into further.

Also, let us know the configuration details of your Azure Cosmos DB account and intended result you need from the PS script.

Thanks.
Sai Praneeth Eranti 170 Reputation points

2024-12-17T12:59:45.33+00:00

Hi ShaktiSingh-MSFT,

Microsoft documentation is the hyperlink in the question . Anyhow , here is the link . https://learn.microsoft.com/en-us/azure/cosmos-db/large-partition-keys?tabs=dotnetv3

When I create container - the expectation is PartitionKeyVersion should have default value other than NULL . And could you please help me what kind of config details you are looking ?
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
ShaktiSingh-MSFT 16,086 Reputation points

2024-12-18T04:57:27.07+00:00

Hi Sai Praneeth Eranti •,

Thanks for providing the details.

You may specify the PartitionKeyDefinitionVersion.V2 property using .NET SDK V3 and V2.

However, if default value is coming NULL for you, could you please let us know if you are using minimum supported .NET version 1.18 as mentioned in the documentation.

https://learn.microsoft.com/en-us/azure/cosmos-db/large-partition-keys?tabs=dotnetv2#supported-sdk-versions

Regarding configuration, I wanted to know the details of you Azure Cosmos DB NoSQL account for which you are working this code.

For the observation, I am working to reproduce the scenario on my DB and checking internally with the intended nature of the version.

Thanks for your patience.
Sai Praneeth Eranti 170 Reputation points

2024-12-18T05:37:30.59+00:00

Hi ShaktiSingh-MSFT,

I'm using powershell script to create container on the Azure Cosmos Account . PowerShell which I'm using is here

Does .NET matter even when we create container using powershell script and run through Powershell ISE?

# Create an Azure Cosmos DB container with default indexes and throughput at 400 RU

$resourceGroupName = "myResourceGroup"

$accountName = "mycosmosaccount"

$databaseName = "myDatabase"

$containerName = "myContainer"

$partitionKeyPath = "/myPartitionKey"

$throughput = 400 #minimum = 400

New-AzCosmosDBSqlContainer -ResourceGroupName $resourceGroupName -AccountName $accountName -DatabaseName $databaseName -Name $containerName -PartitionKeyKind Hash -PartitionKeyPath $partitionKeyPath -Throughput $throughput
ShaktiSingh-MSFT 16,086 Reputation points

2024-12-19T06:10:01.1233333+00:00

Hi Sai Praneeth Eranti •,

Thanks for sharing clear details on the script and issue.

I am checking on this internally and will get back to you.

In the meantime, to avoid NULL, you could explicitly mention Version in the PS script.

Example:

New-AzCosmosDBSqlContainer -ResourceGroupName $resourceGroupName -AccountName $accountName -DatabaseName $databaseName -Name $containerName -PartitionKeyKind Hash -PartitionKeyPath $partitionKeyPath ` -PartitionKeyVersion 2

Thanks.
Sai Praneeth Eranti 170 Reputation points

2024-12-19T07:34:08.8666667+00:00

Hi ShaktiSingh-MSFT,

Yeah , it works fine when I specifiy -PartitionKeyVersion 2 but I'm keen to understand when I don't specify .
ShaktiSingh-MSFT 16,086 Reputation points

2024-12-23T03:58:01.91+00:00

Hi Sai Praneeth Eranti •,

This is to inform you that reply is awaited from the internal team.

Thanks

Share via

PartitionKeyVersion is NULL for the Azure Cosmos Container

Your answer