How to Automate Synapse Link Table Activation and Deployment Across Environments

Question

I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to get the data loaded into ADLS Gen2. This process is labor-intensive, as I have to navigate to each table and activate them individually. Additionally, I need to deploy the same table activation configuration from the development environment to higher environments (test, pre-prod, and prod) without repeating the manual steps.

Questions:

Automating Table Activation:

• How can I automate the activation of tables in Synapse Link for Dataverse to reduce manual effort?

Automated Deployment Across Environments:

  - Once the tables are activated in the development environment, is there a way to automatically deploy or activate the same tables in higher environments (test, pre-prod, and prod) without manually repeating the activation process?
  

Additional Context:

Any guidance on achieving this using Azure Logic Apps, Power Automate, or other automation tools would be highly appreciated. If there are any existing APIs or scripts that can facilitate this process, please provide examples or references.

Thank you in advance for your assistance.

Answer 1

@Amira Bedhiafi

I'm sure they used ChatGPT before asking the question. I was expecting a working solution, and I got an unverified script from ChatGPT pasted as an answer. This has been a waste of my time, and it is unacceptable. I would expect an MS employee to provide the following:
A: A working script
B: A response saying it can't be done (yet)

Can you review your response, please?