Azure Function SQL Trigger Not Finding Table

@Maess

Welcome to Microsoft Q&A!

Thanks for reaching out about the issue with your Azure Function SQL Trigger not recognizing the dbo.ToDo table. We're happy to help you troubleshoot this.

Assuming your table details and connection string are correctly configured in both your Azure Function and SQL database, could you please double-check the permissions granted to the Function App's identity? This could be either its managed identity or the user specified in the connection string.

Specifically, the identity needs the following permissions on the dbo.ToDo table:

SELECT: To read data from the table.

VIEW DATABASE STATE: To query the change tracking metadata, which is essential for the trigger to function correctly.

If you've confirmed these permissions and are still experiencing issues, please provide us with more details about your setup, and we'll be happy to assist you further.

Hello Maess,

Welcome to the Microsoft Q&A and thank you for posting your questions here.

I understand that your Azure Function SQL Trigger fails to start, reporting that it cannot find the dbo.ToDo table.

The below are the steps you will to take to resolve the, use the links for more detail steps:

1. Verify Table Existence - https://zcusa.951200.xyz/en-us/sql/relational-databases/system-information-schema-views/tables-transact-sql
2. Validate Change Tracking - https://zcusa.951200.xyz/en-us/sql/relational-databases/track-changes/about-change-tracking-sql-server and https://zcusa.951200.xyz/en-us/sql/relational-databases/system-catalog-views/sys-change-tracking-tables-transact-sql
3. Check Connection String - https://zcusa.951200.xyz/en-us/azure/azure-functions/functions-app-settings#connection-strings
4. Check Permissions - https://zcusa.951200.xyz/en-us/sql/relational-databases/security/permissions-database-engine and https://zcusa.951200.xyz/en-us/sql/t-sql/statements/grant-database-permissions-transact-sql
5. Validate Schema and Table Name - https://zcusa.951200.xyz/en-us/sql/relational-databases/sql-server-design-best-practices-and-conventions
6. Review Function Configuration - https://zcusa.951200.xyz/en-us/azure/azure-functions/functions-bindings-azure-sql-trigger and https://zcusa.951200.xyz/en-us/azure/azure-functions/functions-dotnet-dependency-injection
7. Analyze Logs for Binding Issues - https://zcusa.951200.xyz/en-us/azure/azure-functions/functions-host-json
8. Test with Simplified Configuration - https://zcusa.951200.xyz/en-us/azure/azure-functions/functions-bindings-azure-sql-trigger#example
9. Verify SQL Compatibility - https://www.nuget.org/packages/Microsoft.Azure.Functions.Worker.Extensions.Sql

If the issue persists after all these steps, verify the following:

• Is the Function App deployed in the correct region and connected to the correct SQL Server instance?
• Does the dbo.ToDo table use any complex types, constraints, or triggers that might interfere with SQL Trigger operations?

I hope this is helpful! Do not hesitate to let me know if you have any other questions.

Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful.