Skip to main content
Version: 0.0.39

PostgreSQL

Integrating PostgreSQL with Lakehousecat allows smooth interaction with your PostgreSQL databases for effective data management and analytics. This guide will walk you through the steps required to set up a PostgreSQL connection within the Lakehousecat workspace.

Prerequisites​

Ensure you have the following before starting the integration process:

  • Access to Lakehousecat as an admin or builder
  • An existing PostgreSQL database with connection credentials

Step-by-Step Guide​

  1. Start in the Workspace

    • Navigate to your Lakehousecat workspace where you manage data connections.

  2. Go to the Data Section

    • Click on the 'Data' menu to explore various data-related options within Lakehousecat.

  3. Select "Datasource Types"

    • To view available data sources, select the "Datasource Types" option.

  4. Choose "PostgreSQL Datasource Type"

    • Click on the "PostgreSQL Datasource Type" to initiate the configuration process.

Step 3: Configure the PostgreSQL Connection​

  • Connection Name: Enter a clear and descriptive name for your connection. This name will be used to identify the connection throughout Lakehousecat.
  • PostgreSQL Connection-Uri: Input the PostgreSQL connection URI in the correct format. Ensure this URI is complete and correct to facilitate a successful connection.
  • Description (Optional): Provide an optional description. This can help other administrators understand the purpose or scope of this connection.

Step 4: Validate and Create the Connection​

  1. After entering the required information, click on the Create button.
  2. Lakehousecat will initiate validation of the connection parameters. Ensure that all details are correct to avoid validation errors.
  3. Once the validation is successful, your PostgreSQL connection will be established and ready for use.

Best Practices​

  • Naming Conventions: Use a consistent naming convention for connection names to improve recognition and manageability.
  • Description Usage: Utilize the description field to provide insights into the connection's intended use, especially if multiple connections exist.

Troubleshooting​

If you encounter issues during the connection setup:

  • Validation Errors: Double-check the PostgreSQL Connection-Uri for correctness.
  • Access Issues: Ensure you have the necessary permissions within both Lakehousecat and PostgreSQL.