Azure Cosmos DB - Understanding a Section Key

I create our first Azure Cosmos database - I will import into the first collection, data from a table in one of our SQL Server databases. When setting up the collection, I had problems understanding the meaning and requirements for the section key, which I should specifically mention when setting up this initial collection.

I read the documentation here: ( https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-partition-data ) and am still not sure how to continue the naming convention for this section key.

Can someone help me understand how I should think of naming this section key? See the screenshot below for the field I'm trying to fill.Section Key Name

In case this helps, the imported table consists of 7 columns, including a unique primary key, a column of unstructured text, a column of URLs and several other secondary identifiers for this URL. Not sure if any of this data has anything to do with how I should name my section.

EDIT: I added a screenshot of several records from the table from which I import, on request from @Porschiey.

enter image description here

+15
source share
5 answers

Honestly, the video here * was the BASIC help for understanding partitioning in CosmosDb.

: PartitionKey - , , .

(, ), , . , ; , , , , .

EDIT: , PartitionKey 10 . ( )


* , MS, " Azure Cosmos DB", . .

+14

CosmosDB . , . , ? -

: (, -, ).

10 , , . . . , .

+6

10 ( ). , , ( ), 10 .

- - ? , .

+3

.

, , ? ; , , , .

?

.

:

SELECT * FROM T WHERE T.CustomerId= 'CustomerId';

var options = new FeedOptions{ PartitionKey = new PartitionKey(CustomerId)};

var query = _client.CreateDocumentQuery(CollectionUri,$"SELECT * FROM T",options).AsDocumentQuery(); 
+2

All Articles