Forum Discussion
Intermittent connectivity issues connecting to lakehouse SQL Analytics endpoint
Hi gmangiante,
According to your description, it seems like more related azure app service release resource which connections used to optimize/reduce the source usage.
Have you tried to add some simply query to request with low frequency as heartbeat to keep connections alive?Regards,
Xiaoxin Sheng
Hi gmangiante,
According to your description, it seems like more related azure app service release resource which connections used to optimize/reduce the source usage.
Have you tried to add some simply query to request with low frequency as heartbeat to keep connections alive?
Regards,
Xiaoxin Sheng
Just to put a pin in this in case anyone else runs across it - I can confirm that the behavior I was seeing has disappeared by implementing a "heartbeat" query to the lakehouse a couple of times a minute. In my case, I chose to do it by starting a looped task via asyncio during my FastAPI lifespan startup. Also, keeping the heartbeat alive means that I don't have to worry about waiting for resources to spin up to answer queries if the lakehouse hasn't been touched in a while! A great solution.