Public Preview: Materialized views for Cosmos DB NoSQL API
Published date: May 23, 2023
This public preview lets you try out the materialized view (MV) for your Cosmos DB NoSQL API accounts. Materialized views help you reduce your query costs and improve query performance without requiring any manual steps apart from defining a materialized view collection on the source container. The MV container automatically gets populated and updated based on the definition. You can define materialized view containers that have a partition key different than the source container’s partition key and fewer selected fields from the source containers depending on the application requirement. By choosing a different and better suited partition key for the business case, you can reduce cross-partition queries; and by storing only the data required for the specific use cases, you reduce the item size. Together, these contribute to further query cost reductions and improved performance.