Hi All.
I have been able to setup synapse link to get data from Dynamics F&O into a datalake and query via the serverless SQL pool, I have got some features that I will like to use which are only possible with a dedicated SQL pool. My question is this, how can one create a way to keep the data in synch with the datalake that synapse link ports across.
Can the pipelines be flexible such that tables can be added & removed, what triggers the data synch or is it just a timed synch, how does it deal with delta and data changes ?
Thanks in advance.