SQL Trigger option missing in Azure Functions extension (v1.15.3) for VS Code

[teohsinyee]

Description:

I'm currently using version 1.15.3 of the Azure Functions extension for VS Code, alongside the latest Azure Functions Core Tools. While trying to create an Azure SQL trigger for my function app, I noticed that the SQL trigger option is missing from the list of available triggers in the "Create Function" panel.

Steps to Reproduce:

1. Install the Azure Functions extension in VS Code (v1.15.3).
2. Open an existing Function App project in VS Code.
3. Use the command palette to create a new function.
4. The list of trigger types (e.g., HTTP, Timer, Blob, etc.) is shown, but SQL Trigger is not available in the list.

Environment Details:

• Azure Functions Extension version: 1.15.3
• Azure Functions Core Tools version: 4.0.5907
• VS Code version: 1.93.0 (user setup)
• OS: Windows_NT x64 10.0.22631

Screenshot:

Here is a screenshot of the available trigger types in VS Code where the SQL trigger option is missing:

[nturinski]

Hi @teohsinyee

Sorry for the late reply. The template triggers are runtime specific so could you please let me know which language you are using?

Also, at the bottom of your screenshot, I can see that you have the filter option on. What do you have that set to?

[teohsinyee]

Hi @nturinski , it is Python, programming model V1; The filter was set to All.

[teohsinyee]

Hi @nturinski , it is Python, programming model V1; The filter was set to All.

Hi @nturinski , is there updates from your side? Issue still persisted as described.

[MicroFish91]

@nturinski is currently out, one of us will need to look into this and get back to you