Cannot establish synapse link connection to azure sql db table (that was previously linked)

Frank Bluemke 1 Reputation point
2023-07-10T21:56:37.4766667+00:00

I had a link connection in my synapse workspace to an azure sql db table. I discovered that the data had not been syncing for the last month (not sure why). as a troubleshooting step i stopped the link, deleted it and then tried to re create it. When i try to start the new link I get this error:There is no available source table that has been enabled successfully for Synapse Link. Continuous run ID: b67f5a88-268c-473b-8a2a-3de7e9dc12ff

I had this happen before and it just eventually went away but i really need to get this table synced tonight if posisble. Does anyone know work around?

Azure SQL Database
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,113 questions
{count} votes