Public Preview: Materialized views for Cosmos DB NoSQL API

Azure Updates

Discussionpowered by zap.ms

Published

May 23, 2023

Status

In preview

Timeline

  • May 2023
    Preview

Product

Azure Cosmos DB

Tag

Features
Microsoft Build

Category

Databases
Internet of Things

Description

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.

Learn More