{"id":6958,"date":"2023-11-02T11:46:57","date_gmt":"2023-11-02T18:46:57","guid":{"rendered":"https:\/\/devblogs.microsoft.com\/cosmosdb\/?p=6958"},"modified":"2023-11-02T11:48:34","modified_gmt":"2023-11-02T18:48:34","slug":"new-features-for-azure-synapse-link-for-azure-cosmos-db","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/cosmosdb\/new-features-for-azure-synapse-link-for-azure-cosmos-db\/","title":{"rendered":"New features for Azure Synapse Link for Azure Cosmos DB"},"content":{"rendered":"

Azure Synapse Link for Azure Cosmos DB<\/a> is a cloud-native hybrid transactional and analytical processing (HTAP) capability that enables near real-time analytics over operational data in Azure Cosmos DB. Azure Synapse Link creates a tight seamless integration between Azure Cosmos DB and Azure Synapse Analytics.<\/p>\n

We are excited to announce the new Azure Synapse Link capabilities that will help you to implement analytics workloads on top of your Azure Cosmos DB data.<\/p>\n

\"Image<\/a><\/h2>\n

<\/h2>\n

Announcing Synapse Link for existing MongoDB collections: General Availability<\/h2>\n

This capability allows the usage of Synapse Link on collections that were created without this feature. Now, you can use CLI or PowerShell to enable Synapse Link on all your existing MongoDB collections, eliminating the necessity of exporting the data to a new collection to use Synapse Link.<\/p>\n

Here is a CLI example of how to turn on Synapse Link on an existing MongoDB collection.<\/p>\n

az cosmosdb mongodb collection update -g <your_resource_group><\/strong> -a <your_database_account><\/strong> -d <your_database><\/strong> -n <your-collection><\/strong> –analytical-storage-ttl -1<\/strong>\u00a0\u00a0<\/em><\/p>\n

A collection\u2019s initial sync with the analytical store total time will vary depending on the data volume and on the document’s complexity. This process can take anywhere from a few seconds to multiple days.<\/p>\n

For more information, click here<\/a>.<\/p>\n

 <\/p>\n

Synapse Link and continuous backup integration are now generally available<\/h2>\n

Now you can turn on Synapse Link on Azure Cosmos DB database accounts that have continuous backup<\/a> enabled.<\/p>\n

You can turn on Synapse Link on continuous backup-enabled accounts using the portal, CLI, PowerShell, and Cosmos DB SDKs. With that, you can use Synapse Link in the same database accounts that already have point-in-time restore (PITR) enabled.<\/p>\n

The opposite situation, to enable continuous backup on Synapse Link enabled accounts, is in private preview and if you want to participate, please register here<\/a>.<\/p>\n

 <\/p>\n

Custom partitioning for analytical store is now generally available<\/h2>\n

 <\/p>\n

Custom partitioning enables you to partition analytical store data using keys, or fields in your documents, that are frequently used filters in your analytical queries, resulting in improved query performance.\u00a0 You can create one partitioned store for each group of keys, with different schedules and filters.<\/p>\n

The partitioned store is persisted in the Azure Data Lake Store that supports your Synapse Workspace, making it easy to visualize the data and manage access.<\/p>\n

For more information, click here<\/a>.<\/p>\n

\"Synapse<\/a>
Synapse Link custom partitioning architecture<\/figcaption><\/figure><\/p>\n

 <\/p>\n

Conclusion<\/h2>\n

Now you can unlock BI, insights, and advanced analytics on top of existing Azure Cosmos DB for MongoDB data, and accounts enabled with continuous backup. If you have advanced scenarios, you can use custom partitioning to improve the performance of your analytical workloads.<\/p>\n

Please contact our team<\/a> with any questions that you may have.<\/p>\n

About Azure Cosmos DB