Create a PostgreSQL Connection
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 new PostgreSQL Connection
Begin from your workspace Super Graph view. Follow these steps to create your connection:
- Using the Connection Form
- Using the Files Panel
- To start creating a connection, either:
- Click the + button next to Connections in the left Build panel
- Or right-click anywhere in the Super Graph and hover over Create Connection
- Name your connection `read_postgresql`
- Select PostgreSQL from the available options
- Complete the required form fields (along with any desired optional fields)
- Scroll to the bottom and click Save to create your Connection

- Open the files panel in the top left corner
- Right-click on the Connections directory and choose New File

- Name your file with a descriptive name like `read_postgresql.yaml` and press enter
To learn more about the different options for Connections, check out our 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>}"