Azure Synapse Link stuck

Today we have a simple trick for a common mistake that can save you a few clicks.

When performing the Azure Synapse Link by enabling the conversion with Spark, the tables that have been enabled may perpetually remain in the "Initial synchronization in progress" state.

One of the solutions is to delete the link and create it again, but what if we have marked many tables? Do we have to look for them again one by one?

Luckily there is another, much simpler solution.

1. We click on the button that allows us to mark the tables we want

2. We display the Advanced tab

3. We modify the time (in minutes) of the incremental to another value (hopefully less than the one we currently have)

4. We save the configuration

This will automatically force the initial sync process to resume or unlock.