topic Lakeflow Connect CDC error, broken links in Data Engineering

Lakeflow Connect CDC error, broken links

dbernstein_tp — Fri, 21 Nov 2025 17:47:16 GMT

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.

Re: Lakeflow Connect CDC error, broken links

bianca_unifeye — Mon, 24 Nov 2025 15:25:18 GMT

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.

Re: Lakeflow Connect CDC error, broken links

Advika — Mon, 24 Nov 2025 15:54:55 GMT

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

Re: Lakeflow Connect CDC error, broken links

dbernstein_tp — Tue, 25 Nov 2025 23:24:53 GMT

@Advika Thank you. My reason for this post was to alert the SQL server ingestion team to this bug in the interface. I will file a report about this (didn't know I could do that) and a few other issues with the feature that I've found recently.