Re: Lakeflow Connect - SQL Server - Database Setup...

Oumeima · ‎03-02-2026

Hello,

Thank you for your reply!

Both ingestion gateway and ingestion pipeline are running correctly. I couldn't spot any a clear error message in the logs but i could troubleshoot something. I tested using a user that has the role "db_owner" (to discard any potential permissions issues). The validation is passing and i could ingest data. So, the service principle i used initially for ingestion is missing permission(s) rather something else.

I already ran the "lakeflowFixPermissions" stored procedure as dictated in the docs. These are the permissions that my service principle has:

Permission source	object name	schema name	object type	permission class	permission name	grant state
EXPLICIT	Table1	dbo	USER_TABLE	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	Table1	dbo	USER_TABLE	OBJECT_OR_COLUMN	VIEW CHANGE TRACKING	GRANT
EXPLICIT	Table2	dbo	USER_TABLE	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	Table2	dbo	USER_TABLE	OBJECT_OR_COLUMN	VIEW CHANGE TRACKING	GRANT
EXPLICIT	DATABASE		NULL	DATABASE	CONNECT	GRANT
EXPLICIT	DATABASE		NULL	DATABASE	VIEW DEFINITION	GRANT
EXPLICIT	DATABASE		NULL	DATABASE	VIEW DATABASE STATE	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	DATABASE		NULL	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	Table3	dbo	USER_TABLE	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	Table3	dbo	USER_TABLE	OBJECT_OR_COLUMN	VIEW CHANGE TRACKING	GRANT
EXPLICIT	lakeflowDdlAudit_1_5	dbo	USER_TABLE	OBJECT_OR_COLUMN	SELECT	GRANT
EXPLICIT	lakeflowDdlAudit_1_5	dbo	USER_TABLE	OBJECT_OR_COLUMN	VIEW CHANGE TRACKING	GRANT
ROLE MEMBERSHIP	db_datareader		DATABASE_ROLE	ROLE	MEMBER OF	GRANT

Is it missing something? Do you have the full list of permissions the ingestion user must have for this to work?

Thank you!