Lakeflow Connect CDC error, broken links

[dbernstein_tp]

I get this error, regarding database validation, when setting up a lakeflow connect CDC pipeline (see screenshot). The two links mentioned in the message are broken, they give me a "404 - Content Not Found" when I try to open them.

 

[bianca_unifeye]

You’re not doing anything wrong – this dialog is actually telling you the fix, the problem is just that the doc links behind it have recently moved (hence the 404s).

What’s happening here:

• Lakeflow Connect created a set of SQL Server utility stored procedures in your source DB (v12demo), e.g.
  lakeflowFixPermissions, lakeflowSetupChangeTracking, lakeflowSetupChangeDataCapture, lakeflowDetectPlatform, lakeflowUtilityVersion_1_1.

• The ingestion user svc_databricks doesn’t have EXECUTE permission on those procedures.

• The validation step picks that up and generates the “fix script” you see in the screenshot.

So the fix is simply to run that script in the source SQL database, as a user with db_owner (or equivalent) privileges.

[Advika]

Sharing a likely doc that should help: https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/sql-server-utility