How to turn off azure synapse link for a container i didn't create it a workspace for it just anabled in azure cosmos db for dev env. My major concern is should i be charged for that?

Question

How to turn off azure synapse link for a container i didn't create it a workspace for it just anabled in azure cosmos db for dev env. My major concern is should i be charged for that?

Answer 1

@crynos_001

Thanks for using Microsoft Q&A forum and posting your query.

To turn off Azure Synapse Link for a container in Azure Cosmos DB, you can set the analytical Time to Live (TTL) to 0 using Azure CLI or PowerShell. This action will disable Synapse Link for the container and permanently delete the analytical store

Here's a quick guide on how to do it:

Using Azure CLI:

az cosmosdb sql container update \
    --account-name <your-account-name> \
    --database-name <your-database-name> \
    --name <your-container-name> \
    --analytical-storage-ttl 0

Using PowerShell:

Update-AzCosmosDBSqlContainer `
    -ResourceGroupName <your-resource-group-name> `
    -AccountName <your-account-name> `
    -DatabaseName <your-database-name> `
    -Name <your-container-name> `
    -AnalyticalStorageTtl 0

Regarding charges, if the Synapse Link capability is enabled at the account level but no analytical store is enabled for any containers, there should be no billing implications

However, if the analytical store is enabled for any containers, you may incur charges based on the storage and usage.I hope this information helps. Please do let us know if you have any further queries.

Kindly consider upvoting the comment if the information provided is helpful. This can assist other community members in resolving similar issues.

Thank you.