To enable analytical queries over Azure Synapse Link from Azure Synapse Analytics, what is required for a container in Cosmos DB?

To enable analytical queries over Azure Synapse Link from Azure Synapse Analytics, it is essential to enable Azure Synapse Link in the container to create an analytical store. This capability allows you to efficiently query your Cosmos DB data using Synapse Analytics without impacting the transactional performance of your workload.

When Azure Synapse Link is enabled, it creates a separate analytical store that is specifically optimized for analytical queries. This store is eventually consistent and can be queried using a SQL-based model, making it ideal for large-scale analytics and reporting tasks. The analytical store supports running complex queries, aggregations, and joins, which are typically required in data analysis and business intelligence scenarios.

The other options do not directly relate to the requirement for enabling analytical capabilities through Azure Synapse Link. For instance, simply deleting and recreating the container or changing the indexing policy does not fulfill the necessary requirement of enabling the link for analytical querying. Similarly, increasing the storage capacity of the container does not impact the analytical store feature provided by Azure Synapse Link.