No http trigers found in python azure function when using sqlalchemy.Works fine locally

Question

I have a python azure function with three http end points. Two end points connect to azure sql server using sqlachemy and orm and the first one connects to open ai. Locally everything works fine and I can use postman to trigger the end points. As soon as I deploy to azure portal I dont see any azure functions. I also noticed that if I remove the dependency on SQLAlchemy and just hard code the results then I can see all the three azure functions. When deploying the azure function using vs code I see

No Http trigger found.

I am on Python 4, linux comsumption plan east us

Answer 1

@Abir Bhattacharyya Thanks for reaching out. It looks like there are dependency issues that would cause this behavior. Please review the Diagnose and solve problems blade on your function app after deploying your application. If you observe module not found error for the sqlalchemy then please verify whether you have specify it in your requirement.txt file for any package management.

In case if those module or dependencies cannot be installed using pip then you need to use build native dependencies or enable remote build.

You can refer to python troubleshooting document for more details.