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

Is there a way to automate this process now? I know this article is a few years old now.

Basically, my use case is that I have a .NET core application that I want to do near real-time analytics against my cosmos db data.

I currently have it working with synapse link enabled on my cosmos container and querying the serverless sql pool as an OPENROWSET query from my application, but the performance is not good. So I want to have a dedicated sql pool for better performance. 

Ideally, I would have a pipeline or something that is constantly taking the synapse link cosmos data and putting it in a dedicated sql pool for me to query in my .NET application. 

This solution seems like the right direction but it's more of a one time load versus having the data frequently updated in the dedicated sql pool when the cosmos db data gets updated.

Thanks!