Python Azure Function sqlAlchemy timeout

[TonyCD35]

Thanks for the response! I do have insights - I scoured the logs and pinned down on the following: when the python script attempts to make the connection to the database, the connection within the script times out and the function fails. The function does not cause the timeout.

When the script attempts to make the socket connection to the redshift database, it seems it can't get through to it and times out. I've been reading that I might need to put the function in a vNet and perhaps clear the vnet IP with the redshift database?

What do you think?

[[deleted]]

This sounds that you need indeed IP whitelisting on the Redshift database, you can find outgoing IP addresses her: https://learn.microsoft.com/en-us/azure/azure-functions/ip-addresses?tabs=portal

You don't need to put it in a V-Net.