Skip to main content
Version: 3.0.0

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:

  1. To start creating a connection, either:
    • Click the + button next to Connections in the left Build panel
    • add_connection
    • Or right-click anywhere in the Super Graph and hover over Create Connection
    • menu
  2. Name your connection `read_postgresql`
  3. Select PostgreSQL from the available options
  4. Complete the required form fields (along with any desired optional fields)
  5. form
  6. Scroll to the bottom and click Save to create your Connection

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>}"