DLT pipeline python stop scanning all databases in source

[turagittech]

Hi All,

I have set up a DLT pipleline for SQL Server to use CDC as per this instruction https://learn.microsoft.com/en-us/azure/databricks/ingestion/lakeflow-connect/sql-server-pipeline I have it in principal working, however, it scans all databases associated with the server. The account can read from any database on that server.

How do I restrict it to only one database. source_catalog doesn't appear to restrict it?

Will I need to create a service principal, or other account and connection, with only read access in the one database?

[Renu_]

Hi @turagittech, to prevent the Databricks CDC pipeline from scanning all databases on your SQL Server, try setting up a new account with read access only to the specific database. Just ensure this account doesn’t have permissions to any other databases on the server, and use its credentials when setting up the connection in Databricks.