Forum Discussion

nitinrahim's avatar
nitinrahim
Brass Contributor
Apr 19, 2024

Azure Cosmos Db Materialized View general availability

Hi Azure Cosmos DB Team,

 

Can you please confirm if materialized view for Cosmos Db is general available now and can be recommended for production workloads? Also lag for materialized view to catchup is dependent on SKU allocation and provisioned RU in source and destination container only? Does consistency have any impact when querying the materialized view query or for the materialized view catcup in case of heavy writes and updates in source container?  If the account is set up with bounded staleness consistency materialized view querying will also have bounded staleness consistency associated with them when using cosmos JAVA sdk for querying? We are using SQL API.

 

With Regards,

Nitin Rahim

5 Replies

  • AbhinavTrips's avatar
    AbhinavTrips
    Icon for Microsoft rankMicrosoft
    Apr 23, 2024

    Thanks for your question nitinrahim!
    Materialized Views for NoSQL API is not GA yet and the timelines will depend on the feature asks from our customers. We are collating a list of use cases and we'll be happy to discuss about that.

    As for the lag, yes - it is dependent on the provisioned RUs in the source and destination container as well as the SKU size provisioned for MV builder.

    Talking about consistency, MVs are always eventually consistent. Irrespective of the consistency level set on your source, the MV containers will follow eventual consistency.

    • nitinrahim's avatar
      nitinrahim
      Brass Contributor
      Apr 23, 2024

      Thanks Abhinav.

      Materialized view would be a good fit for the Customers considering we will have cross partition searches. We were thinking of having the materialized view to suffice the cross partition queries and have the load and point read on the base container and queries against the materialized view and split the RU's allocated between the same so the load/point read and queries are segregated. Synapse Link is not a good fit in our case considering the concurrency requirements and latency requirement. However we do need RBAC Support and Customer managed key support for materialized view as well considering the security requirements and nature of data of the Customer. If these requirements can be incorporated materialized view is a great fit as it simpler to manage than change feed feature and if its GA available Customers will incorporate the same.

  • nitinrahim's avatar
    nitinrahim
    Brass Contributor
    Apr 22, 2024
    Hi Azure Cosmos DB Team,
    Good morning.
    Just following up on the same?

    With Regards,
    Nitin Rahim

Resources