Connect to PostgreSQL Flexibe Server from Azure Machine Learning Pipeline

Amanda Costa Spolti 0

Hi,

I have a Machine Learning Pipeline, a WebApp and a Postgre Flexibe server with private access that was generated when creating the web app.

My pipeline should be able to connect and insert data into the database created. I have read some tutorials but nothing successful. The AML pipeline and Postgre are in different regions.

How can I connect to the database?

Thanks!

Manas Mohanty (Quadrant Resource LLC) 95 Reputation points Microsoft Vendor

2025-01-20T11:03:14.68+00:00

Hi Amanda Costa Spolti,

Welcome to Microsoft Q&A Forum, thank you for posting your query here.

To use a private Postgres SQL server secured against virtual network, you can refer these documentations. Networking with Private endpoint, but please make sure to allow output traffic from Vnet to PostGreSQL IPs or Service tags or subnet in your network security group. Optionally, you can use managed Vnet to avoid networking configuration effort. Inbound and Outbound documentation ML

To use the AML endpoint for invoking, you can install azure_ai extension on the Server to set endpoint URL and authenticate with its key and then invoke the endpoint with select Jsonb records from Postgres Sql table to update a new column to store the predicted valued.

Reference - Invoke with ML studio on PostGres Sql Server .

Thank you.
Manas Mohanty (Quadrant Resource LLC) 95 Reputation points Microsoft Vendor

2025-01-21T08:14:48.47+00:00

Hi Amanda Costa Spolti,

We are checking to see if above information helped.

Thank you.
Manas Mohanty (Quadrant Resource LLC) 95 Reputation points Microsoft Vendor

2025-01-22T04:07:44.52+00:00

Hi Amanda Costa Spolti,

We haven’t heard from you on the last response and was just checking back to see if the give response was helpful.

Thank you.
Manas Mohanty (Quadrant Resource LLC) 95 Reputation points Microsoft Vendor

2025-01-23T04:42:44.65+00:00

Hi Amanda Costa Spolti,

We haven’t heard from you on the last response and was just checking back to see if the give response was helpful.

Thank you.

1 answer

Amira Bedhiafi 28,066 Reputation points

2025-01-20T10:50:01.4166667+00:00
Since the PostgreSQL Flexible Server is private, you need:

A private endpoint configured for the PostgreSQL Flexible Server.

The AML workspace has access to the same VNet where the PostgreSQL Flexible Server is located

Second thing, in your case the AML and PostgreSQL Flexible Server are in different regions, so you need a VNet Peering to connect the VNet of the AML workspace with the VNet of the PostgreSQL Flexible Server. the peering needs to allow traffic flow between VNets and the NSG rules should allow traffic from the AML workspace subnet to the PostgreSQL subnet on port 5432.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Connect to PostgreSQL Flexibe Server from Azure Machine Learning Pipeline

1 answer

Your answer