Hi @shan-databricks ,

The INGESTION_GATEWAY_DDL_OBJECTS_MISSING error means that while CDC is enabled on DB.dbo.client, the LakeFlow-specific DDL support objects (triggers, stored procedures) that allow Databricks to track schema changes (DDL events like ALTER TABLE) are missing. Enabling native SQL Server CDC/CT is not enough — Databricks needs its own overlay objects on top.

You need to:

1. Download & install the utility script

2. Follow the steps of below tutorial:

https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/sql-server-utility

If my answer was helpful, please consider marking it as accepted solution