AMQP Connector Socket Connect Error: TimeoutError in Azure Synapse Notebook

Question

I am trying to access RabbitMQ (hosted in AWS) from Azure Synapse via Python code in Notebooks. Both servers (Azure and AWS) have been configured to access each other like the firewall setup is already completed and I am able to run the same code via Azure VM created in Azure Synapse. But I am unable to access it in Azure Synapse Analytics due to AMQP TimeOut Error. Could you guys help me here?

I tried to create some Vnetz in Azure Synapse portal and also with Linked Services, it was not working but then I tried to access them via Azure Virtual Machine (created within Azure Synapse Analytics), and it worked. But unable to access it in Azure Synapse. Can someone tell me what could help me to access them in my Azure Synapse Analytics (Notebooks)?

Answer 1

Hello @TheNerd Thanks for reaching out on this forum!
Did you try any of the below troubleshooting steps?

1. Check the RabbitMQ logs to see if there are any errors or warnings that could be causing the issue.
2. Try running your Python code on an Azure Virtual Machine within Azure Synapse Analytics to see if the issue is related to the Notebooks environment.

Answer 2

Hi @SatishBoddu-MSFT,
Thanks for your answer. AS I have already mentioned it in the above post, I have tried running the same python code in an Azure VM created within Azure Synapse it ran successfully. So, there seems to be a problem in connection between Azure Synapse Notebooks and RabbitMQ (AWS)