Not able to see SQL Trigger in Azure function app

Question

Not able to see SQL Trigger in Azure function app

Mahesh Nerella 0

Hi Team,

I am trying to explore Azure SQL trigger in azure function app. https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-azure-sql-trigger?tabs=isolated-process%2Cportal&pivots=programming-language-javascript. When i am trying to create function app i don't see a SQL. trigger option in the list. I am from walmart. Is there anything we need to do ?

Screenshot 2023-10-05 at 1.02.49 AM

Screenshot 2023-10-05 at 1.03.14 AM

Mahesh Nerella 0 Reputation points

2023-10-05T14:55:48.1433333+00:00

Thank you @JananiRamesh-MSFT . How to install the preview extension library in azure portal because i am trying to create through azure portal.
JananiRamesh-MSFT 29,261 Reputation points

2023-10-05T16:59:41.39+00:00

Hi Mahesh Nerella Thanks for getting back, to install the preview extension library in the Azure portal, you need to manually create an extensions.csproj file in the root of your function app. please refer https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-register#explicitly-install-extensions
JananiRamesh-MSFT 29,261 Reputation points

2023-10-09T05:21:03.3766667+00:00

@Mahesh Nerella Just circling back to see if the provided suggestions helped resolve your issue. Let us know if you have any further questions on this topic so we can better assist you.
JananiRamesh-MSFT 29,261 Reputation points

2023-10-13T06:34:28.7233333+00:00

@Mahesh Nerella I hope the answer helps. Please let me know if you have any further queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

1 answer

Your answer

Mahesh Nerella 0 Reputation points

2023-10-05T14:55:48.1433333+00:00

Thank you @JananiRamesh-MSFT . How to install the preview extension library in azure portal because i am trying to create through azure portal.
JananiRamesh-MSFT 29,261 Reputation points

2023-10-05T16:59:41.39+00:00

Hi Mahesh Nerella Thanks for getting back, to install the preview extension library in the Azure portal, you need to manually create an extensions.csproj file in the root of your function app. please refer https://learn.microsoft.com/en-us/azure/azure-functions/functions-bindings-register#explicitly-install-extensions
JananiRamesh-MSFT 29,261 Reputation points

2023-10-09T05:21:03.3766667+00:00

@Mahesh Nerella Just circling back to see if the provided suggestions helped resolve your issue. Let us know if you have any further questions on this topic so we can better assist you.
JananiRamesh-MSFT 29,261 Reputation points

2023-10-13T06:34:28.7233333+00:00

@Mahesh Nerella I hope the answer helps. Please let me know if you have any further queries.

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.

Answer 1

Hi Mahesh Nerella Thanks for reaching out. The Azure SQL trigger for Azure Functions is currently in preview and requires that a preview extension library or extension bundle is used.

If you don’t see the SQL trigger option in the list, it might be because the feature is still in preview, or it might not be enabled in your current environment. You may need to check if the preview extension library or extension bundle is properly installed and enabled. User's image

let me know incase of further queries, I would be happy to assist you.

Share via

Not able to see SQL Trigger in Azure function app

1 answer

Your answer