How to disable the Materialized Views for NoSQL API (preview) in CosmosDB?

Question

How to disable the Materialized Views for NoSQL API (preview) in CosmosDB?

Čončka Jan 0

I have a CosmosDB with NOSQL API and I would like to turn on the Continuous backup. I am receiving the error that it cannot be turned on due to the active Materialized Views for NoSQL API. In Settings/Features I can indeed see the feature active, but I don't see any way to disable it.

Please advise how to proceed.

ShaktiSingh-MSFT 16,251 Reputation points

2025-03-04T14:15:31.6+00:00

Hi Čončka Jan •,

Welcome to Microsoft Q&A forum.

As I understand, you are unable to disable Materialized view from your Cosmos NoSQL account.

I am checking internally on this feature availability via portal and CLI and will get back to you.

Thanks

2 answers

Your answer

ShaktiSingh-MSFT 16,251 Reputation points

2025-03-04T14:15:31.6+00:00

Hi Čončka Jan •,

Welcome to Microsoft Q&A forum.

As I understand, you are unable to disable Materialized view from your Cosmos NoSQL account.

I am checking internally on this feature availability via portal and CLI and will get back to you.

Thanks

Answer 1

Hi Čončka Jan •,

Thanks for your patience.

I have checked internally and is informed that:

Materialized views can’t be disabled on an account once enabled.

This warning was removed in error, and we will update the text in the Portal and the public docs as soon as possible. We apologize for the inconvenience caused.

However, if you feel this functionality should be enabled, we encourage you to raise your feedback over Feedback Channel Azure Cosmos DB: Azure Cosmos DB · Community.

Team will look into the feature request depending on the up-votes and priority to work.

Please let us know if you have further queries.

Thank you.

Answer 2

Sina Salam 18,876

Hello Čončka Jan,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that you would like to disable the Materialized Views for NoSQL API (preview) in CosmosDB.

To disable the Materialized Views for NoSQL API (preview) in your Azure CosmosDB account, you can follow these steps:

Sign in to the Azure portal and navigate to your Azure Cosmos DB for NoSQL account.
Go to the Settings section in the resource menu.
Locate the Features section under Settings.
Toggle off the Materialized View for NoSQL API (preview) option.

If you don't see an option to disable it directly, you might need to use the Azure CLI or REST API to manage this feature:

Using Azure CLI

Open your Azure CLI.
Run the following command to disable the materialized views feature:

az cosmosdb update --name <your-cosmosdb-account-name> --resource-group <your-resource-group-name> --set properties.materializedViewsEnabled=false

Using REST API

Make a PATCH request to the Cosmos DB account endpoint with the following payload:

   {
     "properties": {
       "materializedViewsEnabled": false
     }
   }

I hope this is helpful! Do not hesitate to let me know if you have any other questions or clarifications.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.

Prasad Chaganti 80 Reputation points Microsoft External Staff

2025-02-27T08:34:19.2833333+00:00

Hi Čončka Jan,

Just checking in to see if the below answer provided by @ Sina Salam.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Čončka Jan 0 Reputation points

2025-02-27T12:28:46.28+00:00

Hi and thanks for quick response.

In the Azure portal, I can see the feature "Materialized Views for NoSQL API (preview)" and its on. There is no option to switch it off.

the az cosmosdb update ... ... ... command failed with error "unrecognized arguments: --set properties.materializedViewsEnabled=false"

The PATCH request to the DB's endpoint succeeded with HTTP status 200 and response body contained lot of stuff, including list of properties, but nothing related to materialized view was among them.

The Resource (CosmosDB) has still the feature Materialized Views for NoSQL API (preview) on.
Sina Salam 18,876 Reputation points

2025-02-28T10:37:43.1233333+00:00
Hello

The instructions in the answers are not independent, you have to create ARM templates and modify the json file. Because to enabling or disabling materialized views might not be directly supported through the Azure CLI.

Check that you have the necessary permissions to update the Cosmos DB account and make sure you are using the latest version of the Azure CLI.

If the previous command is not working for you due to any reason, update properties of a Cosmos DB account, by using the Azure portal or an ARM template. Again, this an example of how you can update a property using an ARM template:

Create a JSON file (e.g., update-cosmosdb.json) with the desired properties:
{ "properties": { "materializedViewsEnabled": false } }

Use the Azure CLI to deploy the template:
az deployment group create --resource-group myResourceGroup --template-file update-cosmosdb.json
NOTICE: The resource group and file name must be yours.

Goodluck
Čončka Jan 0 Reputation points

2025-02-28T15:20:36.4266667+00:00

Thanks for your response again.

I had another look and according to this the property is called enableMaterializedViews. Maybe the name has changed...

The az cosmosdb update command has a switch --enable-materialized-views which can be used, as it turns out, only to enable the feature.

When I tried to disable the feature either using the az command or the rest API the response was: (BadRequest) EnableMaterializedViews cannot be disabled once it is enabled on an account.

I am surprised this is not mentioned anywhere. But it would explain why there is no switch for it in Azure portal.

The Goodluck comes maybe next time, unless you know better than that and have some insider information.

Share via

How to disable the Materialized Views for NoSQL API (preview) in CosmosDB?

2 answers

Your answer