How to assign a Cosmos dataset container dynamically with Azure Synapse

Question

Hi,

I am setting up a pipeline to backup all containers from multiple Cosmos databases. I can parameterize the linked service just fine, but I cannot see a way to dynamically parameterize the Cosmos Container when creating the integration dataset. I am trying to avoid creating a Dataset per container, is there a way to achieve that?

Answer 1

Hi @Michel Galibois ,

Welcome to Microsoft Q&A platform and thanks for posting your question here.

As I understand your query, you are trying to parameterize CosmosDB dataset so as to use it for multiple containers. Please let me know if that's not the ask here.

Could you please share which cosmos API you are using (mongodb or nosqldb).

I tried to create a dataset for noSQL and didn't face any issue parameterizing it. Kindly have a look at the below video and let me know if it helps:

Hope this will help. Please let us know if any further queries.

------------------------------

• Please don't forget to click on or upvote button whenever the information provided helps you.
  Original posters help the community find answers faster by identifying the correct answer. Here is how
• Want a reminder to come back and check responses? Here is how to subscribe to a notification
• If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

Answer 2

Hi @AnnuKumari-MSFT ,
This works great! I was kind of stuck because I was under the impression that I would see "add dynamic content" under the container entry in the dataset, I am still fairly new to Synapse.
Thank you for the fast and precise answer