Great series of articles Brad, I am stuck on some permission issue though when running the deployment in ADO. I get the error:
Getting Artifacts from workspace: <target workspace name>.
Failed to fetch workspace info, status: 403; status message: Forbidden
Error during execution: Failed to fetch workspace info Forbidden
Now I figure it is because the Service Account we use in ADO doesn't have access to the target workspace, so I added them as Synapse Administrator, however I still get the error. In your previous post you said "*a quick side note, make sure the AAD account you are using to connect to Azure DevOps is the same account that has permissions to your Azure Synapse Studio workspace.", which I am sure I have done (basically I have given everyone Synapse Administrator and I still get the issue!). Are we supposed to also set something else up in the Synapse IAM roles?
Edit: Don't worry about this - there were about 20 service principals with the same name, I added them all as Synapse Administrators and I was successful at pushing through changes. Leaving this here in case it helps others.