Ingestion Gateway DDL Objects Missing - Lakeflow Connect

shan-databricks — Mon, 25 May 2026 13:04:21 GMT

Facing below issue and need a solution to proceed further

Category: Error
Message: DDL objects missing on table 'DB.dbo.client'. Execute the DDL objects script and full refresh the table on the Ingestion Pipeline. Error message: '

Reason:
- Catalog is not properly configured to capture DDL changes for the provided set of tables.

How to fix:
- To capture DDL changes for a table with LakeFlow Connect, appropriate set of support objects must be setup on the catalog. Different support objects are needed depending if tables that are replicated are using CT and/or CDC extraction mechanism.
- Investigation shows that only CDC tables are included in the replication, but corresponding DDL support object do not exist in the catalog.
- Please check the documentation for information on how to properly set up the catalog for DDL capture. Link to the related documentation is provided below under 'Useful links' section.
- To create the missing support objects, please execute the T-SQL script on this catalog in 'CDC' mode. This will create CDC related support objects. Alternatively, script can be executed in 'BOTH' mode, which will create both CT and CDC support objects.

Useful links:
- Setting up Change Tracking (CT) on SQL Server: https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/sql-server/change-tracking#set-up-ddl-capture-and-schema-evolution
- Setting up Change Data Capture (CDC) on SQL Server: https://docs.databricks.com/aws/en/ingestion/lakeflow-connect/sql-server/cdc#set-up-ddl-capture-and-schema-evolution'.
Error class: INGESTION_GATEWAY_DDL_OBJECTS_MISSING
SQL state: 42000

Re: Ingestion Gateway DDL Objects Missing - Lakeflow Connect

szymon_dybczak — Mon, 25 May 2026 16:40:20 GMT

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

topic Re: Ingestion Gateway DDL Objects Missing - Lakeflow Connect in Data Engineering

Ingestion Gateway DDL Objects Missing - Lakeflow Connect

Re: Ingestion Gateway DDL Objects Missing - Lakeflow Connect