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

Hi @Thijs Verweij,

Welcome to the Microsoft Q&A Platform! Thank you for reaching out regarding the Azure SQL trigger binding for Azure Functions.

Currently, the Azure SQL trigger binding is in preview, which means it has limited support and may not appear by default in some development environments, including Visual Studio Code. This binding is still evolving, so there may be additional setup steps needed to get it working in the Python V2 model.

Since the SQL trigger may not appear in the Visual Studio Code UI, you can manually add it to your function code as described in Azure's SQL trigger documentation. Be sure to specify the database and table you want to monitor and configure the trigger settings directly in your function file.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.