Azure Cosmos DB Adapter Limitations

Supported Types
Precision of number Type
Special Item Names
Consistency

This operation uses DocumentDB API of Azure Cosmos DB. For more details on API specifications, refer to the following page.

"Azure Cosmos DB: DocumentDB REST API Reference" (https://docs.microsoft.com/en-us/rest/api/documentdb/)

Supported Types

Correspondence of the JSON types of Azure Cosmos DB supported by this adapter and the internal data types (schema types) is as follows.

Azure Cosmos DB data type name	Support	Schema type name	Remarks
string	Yes	String
number	Yes	BigDecimal
true/false	Yes	boolean
null	Yes	-	Treated as null regardless of the schema type.
object	No	-
array	No	-

Yes: Supported.
No: Not supported.

Precision of number Type

Number type in Azure Cosmos DB is IEEE754 double precision.

If the number that exceeds IEEE754 double precision is written to Azure Cosmos DB as BigDecimal type, it will be rounded off. (It will not be an error)
To avoid rounding off, set schema type as String type when writing the document.

However, as it is saved as string type in Azure Cosmos DB, SQL for number will no longer be able to be used.

Special Item Names

“_rid”, “_ts”, “_self”, “_etag”, “_attachments”, etc. are the items generated by Azure Cosmos DB for a document. You cannot write arbitrary value for these items.

As name of item generated by Azure Cosmos DB starts with an underscore (_), it is recommended to set item names for schema such that there is no underscore at the start of the names.

For more details on items generated by Azure Cosmos DB system, refer to the following pages.

“System vs. user defined resources” - (https://docs.microsoft.com/en-us/azure/cosmos-db/documentdb-resources#system-vs-user-defined-resources)
"Documents" - (https://docs.microsoft.com/en-us/rest/api/documentdb/documents)

Consistency

In Azure Cosmos DB adapter, among the 5 types of consistency ("Strong", "Bounded-Staleness", "Session", "Consistent Prefix", "Eventual"), "Session" is used.

For more details on consistency of Azure Cosmos DB, refer to the following page.

"Tunable data consistency levels in Azure Cosmos DB" - (https://docs.microsoft.com/en-us/azure/cosmos-db/consistency-levels)