How to implement a Python sql trigger V2 function app?

Question

Hello,

I am trying to get the Python SQL trigger to work in Azure functions (https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql-trigger?tabs=isolated-process%2Cpython-v2%2Cportal&pivots=programming-language-csharp). However, when I create the V2 model function app in Visual Studio Code, the SQL trigger is not listed:

Azure Function Core Tools version: v4.0.6543

Is there anything that I am missing here?

Answer 1

@Thijs Verweij ,

Thank you for your patience and for sharing your feedback on the Q&A community platform. I’m glad to hear that you were able to resolve your issue, and I appreciate you sharing your solution! Your contribution is valuable and can help others in the community facing similar challenges.

As per the Microsoft Q&A community policy, "The question author cannot accept their own answer. They can only accept answers by others"

I’m reposting your solution here so you can mark it as accepted if it resolves your query:

"I tried to manually add to my function code as described in the documentation. However, this did not work using the settings described for the host.json, resulting in an error concerning the SQL binding extension. Instead, I used the settings for host.json as described in this GitHub page: Azure Functions SQL Extension Samples. This resolved the issue concerning the SQL binding extension."

Additionally, I will check with the internal team regarding the trigger documentation to ensure clarity on this process.

Please let me know if you need any further assistance.