To search by array length in Azure Cosmos DB while minimizing cost, use a query that filters based on the length property, e.g., SELECT * FROM c WHERE ARRAY_LENGTH(c.arrayField) > 2. Keep the cost lower by ensuring your collection is well-indexed for the queried property and by using appropriate throughput (RU) settings for efficient execution.
how do you search based on array length and keep it cheap
To search by array length in Azure Cosmos DB while minimizing cost, use a query that filters based on the length property, e.g., SELECT * FROM c WHERE ARRAY_LENGTH(c.arrayField) > 2. Keep the cost lower by ensuring your collection is well-indexed for the queried property and by using appropriate throughput (RU) settings for efficient execution.
datetimebin does not appear to be documented anywhere