Azure Synapse Link now supports querying Azure Cosmos DB data using Synapse SQL serverless. This capability, available in public preview, allows you to use familiar analytical T-SQL queries and build powerful near real-time BI dashboards on Azure Cosmos DB data.
Learn about new system functions for working with dates and times in Azure Cosmos DB
With our latest service update, you can now create wildcard indexes in accounts that use Azure Cosmos DB’s API for MongoDB. Wildcard indexes are a popular feature in MongoDB 4.2 that allow you to index many properties without enumerating each one.
Azure Cosmos DB now supports case-insensitive Contains, StartsWith, EndsWith, and StringEquals. Additionally, both Contains and EndsWith have had significant performance improvements. You can now store string data in Azure Cosmos DB without having to worry about matching the case in the query.
Support for two different types of spatial data has been added to Azure Cosmos DB. Using the SQL (Core) API: geography data (round-earth coordinate system), and two-dimensional geometry data.
We are constantly adding new query and indexing features to Azure Cosmos DB. This blog outlines a few recent query and indexing improvements for aggregates, inequality filters, and dates and time system functions. This blog covers updates during the first four months of 2020.
