Network Connection
This article introduces Warehouse's network connection solution.
1. Connection Options
Warehouse offers two network connection options:
-
Classic Network (Public Network): The most straightforward way to connect to Warehouse is via the public network. For security reasons, public network access is restricted by default and must be enabled manually. Access this option at
Warehouse > Networks.
-
Private Network (VPC): Each Warehouse instance operates within an independent VPC network environment, ensuring high security. VPC network access is enabled by default, and endpoints can be created through the PrivateLink solution to connect to Warehouse.
2. Steps to Create a VPC Endpoint Connection
The process for creating a VPC endpoint varies slightly across different cloud providers. For detailed steps, refer to the following document:
3. Enable the Connection
The Warehouse endpoint service does not support automatic acceptance of endpoint connections. After creating an endpoint in step 2, its connection to the endpoint service will be pending. The endpoint can only connect to Warehouse via VPC after Warehouse approves the connection request.
Required information for connection activation includes 1) the connection name and 2) the terminal node ID. The approval process typically takes 1 to 2 minutes.
4. Use the Endpoint to Connect to the Warehouse
Once the endpoint connection is successfully established, you can view the endpoint connection you created and obtain the connection information for accessing Warehouse at Warehouse > Networks.
Several tools and technologies within the Postgres ecosystem can connect to Warehouse, including psql, pgAdmin, JDBC Driver, and others.
- PSQL Command:
- JDBC String:
Parameters
| Parameter | Description | Value |
|---|---|---|
| HOST | Warehouse Connection Domain Name or IP | Query directly on the Warehouse details page. After successful approval of the terminal connection, the backend will automatically retrieve the IP address of the terminal node for convenient connection and usage. Log in to the cloud platform terminal node control console and navigate to the terminal node details page to obtain further information. |
| PORT | Warehouse Connection Port | The default value is 5432. Detailed information can be verified on the Warehouse details page. |
| ACCOUNTNAME | Login Account | |
| PASSWORD | Login Password |
5. Delete the Endpoint Connection
If the endpoint is no longer needed to connect to Warehouse, or if Warehouse itself is no longer required, promptly remove the endpoint connection to sever its association with the Warehouse endpoint service. To minimize costs, log in to the cloud platform's endpoint management console and delete the corresponding endpoint as soon as possible.