Loading CosmosDB and Dataverse data into dedicated SQL pool(DW) using the Synapse link

Unfortunately I did not find a solution using this particular approach. My end solution ended up being using Azure Data Factory and the CDC feature. I setup a trigger and enabled change detection on the cosmos container. When the changes happen I trigger a dataflow that copies the data from cosmosdb to sql server. Hopefully this can help you too. I also looked into Fabric, but since it's still in preview I didn't think it was sufficient for our needs.