I have a container in Cosmos DB with around 10 million documents. This is taking around 3 hours to load from Databricks using cosmos.oltp library integration.

On cosmos DB we see lot of 429 errors which retry automatically.

There is one partition on an ID and one index. Is this partition key , ID is a logical partition? Can this only write to one physical partition with a maximum throughput of 10000 RUs?

Can we add multiple physical partitions to single logical partition?

Do we need to create multiple logical partitions to improve throughput performance so that each physical partition can handle 10K RUs?

Please enlighten
Thanks