PostgreSQL

This guide shows you how to create a PostgreSQL Connection in Ascend.

Prerequisites

• Ascend Project
• Ascend Workspace
• Credentials for your PostgreSQL database
  • Username: Username of the account used to connect to the PostgreSQL server
  • Password: Password of the account used to connect to the PostgreSQL server

Create a PostgreSQL Connection

From your workspace Super Graph view, follow these steps:

Form

1. Create a Connection by either:
   • Clicking the + button next to Connections in the left Build panel
   
   • Right-clicking in the Super Graph and selecting Create Connection
   
2. Enter a descriptive name like `read_postgresql`
3. Select PostgreSQL from the available options
4. Fill in the required fields (and any optional fields as needed)
5. Click Save at the bottom to create your Connection

Files panel

1. Open the Files panel in the top left
2. Right-click the Connections directory and select New File

3. Give your file a descriptive name like `read_postgresql.yaml`

For complete configuration options, see our Connection reference guide.

Example

Use the following YAML template for your PostgreSQL Connection. Customize the highlighted placeholder values with your specific Connection details:

/my_project/connections/postgresql_connection.yaml

connection:
  postgres:
    host: <hostname>
    port: 5432 # default value is 5432, can modify as needed
    database: <database>
    schema: <schema>
    user: <username>
    password: "${vaults.<your_vault>.<password>}"

🎉 Congratulations, you just set up a PostgreSQL Connection in Ascend!