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?